Daily avg of "approx count distinct"?

Avatar

Avatar
Validate 10
Level 4
alv123456
Level 4

Likes

71 likes

Total Posts

118 posts

Correct reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 10
Level 4
alv123456
Level 4

Likes

71 likes

Total Posts

118 posts

Correct reply

4 solutions
Top badges earned
Validate 10
Validate 1
Boost 50
Boost 5
Boost 3
View profile
alv123456
Level 4

11-09-2019

Hi,

besides the unique visitors metric we have a calculated metric based on logged in users which tells us the amount of distinct users - for this we use the built in function "Approximate count distinct". How do I create a new calculated metric for an daily average for that metric?

Normally I'd use the metric and divide it per times of days (which I get using approximate count distinct on days). But this doesn't work, because the dividend in this case would not be the sum of daily users but rather the distinct number of users for the time period!

2019-09-11_0958.png

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

11-09-2019

I encourage you to look at processing rules.

Unique Processing Rules

They are great at allowing you to take variables and then make new Calculated ones.

Good luck to you.