Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

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

wilcro
Level 3

Likes

37 likes

Total Posts

15 posts

0 solutions
View profile

wilcro
Level 3

Likes

37 likes

Total Posts

15 posts

0 solutions
View profile
wilcro
Level 3

19-02-2018

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.

wilcro
Level 3

Likes

37 likes

Total Posts

15 posts

0 solutions
View profile

wilcro
Level 3

Likes

37 likes

Total Posts

15 posts

0 solutions
View profile
wilcro
Level 3

19-02-2018

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

Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

0 solutions
View profile

Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

0 solutions
View profile
Brandon_George_
Employee

19-02-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.

wilcro
Level 3

Likes

37 likes

Total Posts

15 posts

0 solutions
View profile

wilcro
Level 3

Likes

37 likes

Total Posts

15 posts

0 solutions
View profile
wilcro
Level 3

20-02-2018

Brilliant - thanks Brandon.

cgarzi
Level 2

Likes

4 likes

Total Posts

15 posts

0 solutions
View profile

cgarzi
Level 2

Likes

4 likes

Total Posts

15 posts