Daily average Unique Visitors Calculated Metric

Forum|Forum|1 year ago
July 31, 2024
1 reply
1737 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Isha__Gupta

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-visitors/

Isha__GuptaAccepted solution

New Participant

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-visitors/

Bhushan_MahajanAuthor

New Participant

Thank you so much @isha__gupta

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

Josh__Stephens

New Participant

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded