Daily average Unique Visitors Calculated Metric

[Bhushan_Mahajan]

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.

[igupta · Accepted solution]

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

[Bhushan_Mahajan]

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.

[Josh__Stephens]

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.