Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Daily average Unique Visitors Calculated Metric

Avatar

Level 2

Hello,

 

I am trying to create a calculated metric which will get daily unique visitors dynamically if we change the date from. But not able to get the no of days dynamically when the panel date changes.

e.g. if I change the panel date for 30 days it should divide UV with 30 and give average daily unique visitor. 

Thank you in advance.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 5

I think Fred has explained beautifully what you are trying to achieve in his blog post here -

 

Link - https://www.fullstackanalyst.io/blog/blogging/analysis-workspace-hacks-age-average-daily-unique-visi...

View solution in original post

3 Replies

Avatar

Correct answer by
Level 5

I think Fred has explained beautifully what you are trying to achieve in his blog post here -

 

Link - https://www.fullstackanalyst.io/blog/blogging/analysis-workspace-hacks-age-average-daily-unique-visi...

Avatar

Level 2

Thank you so much @igupta 

This was crisp. So we need to use  Approximate Count Distinct Function to get the unique count of dimension items.

Avatar

Community Advisor

That's correct.  Be aware that the function doesn't count values that are included in (Low Traffic).  That caveat can cause large discrepancies depending for dimensions that receive very high volume of unique values.

Here's documentation for the function itself.  And that documentation links to details on low traffic as you scroll down.