Calculated Metric Function: Count Items. For averages (e.g. Visitors per month) and more | Community
Skip to main content
W
willcro
Level 2
February 19, 2018
Delivered

Calculated Metric Function: Count Items. For averages (e.g. Visitors per month) and more

  • February 19, 2018
  • 4 replies
  • 6415 views

A function within calculated metrics which gives the ability to use the number of a specific item. See mocked-up screenshots below for example. As far as I can tell this doesn't exist now? Correct me if I am wrong.

Practical uses (I can think of so many company-specific uses but they will be meaningless so here are a few generic ones)

1) Unique Visitors / Counted months

2) Show number of countries visiting each page

Product PageCounted countriesRevenue per Country
Product A674,123

Product B

226,060
Product C1011,111

3) Show volume of different pages viewed each day to spot trends

DayPages counted (i.e. viewed)
Jan 1st121

Jan 2nd

111
Jan 3rd100
etc.

    4 replies

    W
    willcroAuthor
    Level 2
    February 19, 2018

    This expands on the idea here: Time units in Calculated Metrics 

    B
    Adobe Employee
    Brandon_George1Adobe Employee
    Adobe Employee
    February 20, 2018

    Good news!  We actually released this last year - there is a function in the Calculated Metric Builder called "Approximate Count Distinct", and it works exactly like you've diagramed - it takes a dimension, and gives you a count of the unique number of items for that dimension.

    W
    willcroAuthor
    Level 2
    February 20, 2018

    Brilliant - thanks Brandon.

    C
    cgarzi11
    Level 2
    July 10, 2018

    Hi Brandon,

    Is there any movement towards removing the "approximate" to have an exact count? The numbers are off by 1,000+ in my dashboard when I use approx. count distinct vs looking at the number of rows.

    Terms & ConditionsAccessibility statement

    Loading footer...