Distinct Dimension count with metric => x

Forum|Forum|8 years ago
January 9, 2018
13 replies
10725 views

I've noted the function 'Approximate Count Distinct' which could be used for a count of the distinct values for a dimension however I'd like to extend this further and only count the distinct count where the value has had => specified metric value.

eg.

Distinct Headline count that have had 10 or more Page Views.

I'm able to achieve this if the table breakdown (rows) is headline but not without.

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Gigazelle

I don't think there's a solid answer here within workspace, as there is a paradox of requirements:

The ability to trend articles such as this would necessitate a segment, as separating it by month would require the 100+ page view requirement to be met every month, not just across the reporting period.
Segments are based on users to your site (hits/visits/visitors), not variable values. A segment cannot be defined as "only use articles where there were more than 100 page views across the reporting range". That definition couldn't fit into a hit/visit/visitor container. This is why a calculated metric works.

The only way I anticipate you'd be able to do this is by using report builder to create a separate request for each date range, then create a line chart in excel that takes the table values and trends them.