Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

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

Avatar

Level 3

2/19/18

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.

count dimension.jpg

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 Comments

Avatar

Employee

2/19/18

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.

Avatar

Level 2

7/10/18

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.