Distinct Dimension count with metric => x | Community
Skip to main content
mubarakd5726232
mubarakd5726232
Level 4
January 9, 2018
Solved

Distinct Dimension count with metric => x

  • January 9, 2018
  • 13 replies
  • 10726 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.  

    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.

    13 replies

    Show previous replies
    marion33678522
    marion33678522
    Level 5
    February 9, 2018

    I was talking about putting a Time Range on top of your metric, but yeah, I'm not sure it will work with the column sum, since it will probably count the columns of the current time :

    Gigazelle
    Adobe Employee
    GigazelleAdobe EmployeeAccepted solution
    Adobe Employee
    February 13, 2018

    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.

    J
    JimKultgen
    Level 2
    July 18, 2018

    Pretty certain you can achieve this if you are willing to use a bar graph in lieu of a line graph.

    Calculated Metric

    Column Sum [If page views > 100, 1, else 0]

    Use month as a dynamic column header below the metric.

    Drop page or whatever you dimension is into the table.

    Select the dimension title and viz as a bar graph.

    This works for values that exceed a threshold, its impossible to use this for values below a threshold (less than 100) because if a user doesn't view a product at least once it would not exist in the reporting window (IE would only return values that were seen at least once in the overall time frame, but less than 100 times.  If that is satisfactory you could just flip the 0's and 1's in the calculated metric.

    Terms & ConditionsAccessibility statement

    Loading footer...