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!
SOLVED

average daily unique user measure for month/Week

Avatar

Level 2

 

I am trying to build average daily unique user measure for month dimension in workspace .

I could achieve the daily average Number for additive measure like pageview, but I couldn’t find any solution available in experience league for user measure . How could we build ‘average daily unique user’ calculated measure for month dimension /date component ? I below screen shot – I am looking for ‘Mean Unique Visitor ’ day value in month granularity  

 
 

Adobe.png

 

1 Accepted Solution

Avatar

Correct answer by
Level 4

It won't be perfect, but you could try unique visitors / ceiling(approximate count distinct(days))

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

It won't be perfect, but you could try unique visitors / ceiling(approximate count distinct(days))