Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

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

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 3
wilcro
Level 3

Likes

33 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
wilcro
Level 3

Likes

33 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
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.

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

Avatar
Validate 1
Level 3
wilcro
Level 3

Likes

33 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
wilcro
Level 3

Likes

33 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
wilcro
Level 3

19-02-2018

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

Avatar

Avatar
Employee
Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

Correct Reply

0 solutions
View profile

Avatar
Employee
Brandon_George_
Employee

Likes

0 likes

Total Posts

179 posts

Correct Reply

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.

Avatar

Avatar
Validate 1
Level 3
wilcro
Level 3

Likes

33 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
wilcro
Level 3

Likes

33 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
wilcro
Level 3

20-02-2018

Brilliant - thanks Brandon.

Avatar

Avatar
Validate 1
Level 2
cgarzi
Level 2

Likes

4 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
cgarzi
Level 2

Likes

4 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
cgarzi
Level 2

10-07-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.