Distinct Dimension count with metric => x | Community
Skip to main content
mubarakd5726232
mubarakd5726232
Level 4
Jan 9, 2018 1:41 PM UTC
Solved

Distinct Dimension count with metric => x

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.
    Gigazelle
    GigazelleAccepted solution
    Employee
    Feb 13, 2018 11:01 PM UTC

    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.

    View reply

    13 replies

    Show previous replies
    Gigazelle
    Gigazelle
    Employee
    Jan 16, 2018 6:57 PM UTC

    Viewed X number of times per individual, or total across your site?

    Translate
    mubarakd5726232
    mubarakd5726232Author
    Level 4
    Jan 10, 2018 5:11 PM UTC

    Arun,

    Thanks for the suggestion, let me clarify further..

    I'd like to report on articles that have been viewed more than x no. of times in a specified time frame and not by visitor/visit container.

    so I could then report on ..

    1. No of articles published (distinct count)

    2. No of articles published with 10 or more page views

    .. to then produce KPI % of articles published with more/less than 10 page views.

    as your segment is visit based it wouldn't do what's required.

    Translate
    PratheepArunRaj
    PratheepArunRaj
    New Participant
    Jan 10, 2018 8:51 AM UTC

    Dear Mubarak,

    Thanks for your idea to count the unique items of a variable using Calculated Metric. It was a new technique to me!

    For the above, adding Segment to the function will help to solve?

    What i have done is,

    Created a segment with Page Views >= 10 in a Visit and used that in Calculated Metric.

    First Segment Container and then Function for distinct count.

    Will this help?

    Thank You!

    Arun

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...