Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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))