Daily average Unique Visitors Calculated Metric

Forum|Forum|1 year ago
July 31, 2024
1 resposta
1737 Visualizações

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.

Este tópico foi fechado para respostas.

Melhor resposta por 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 Gupta

Resposta

Community Advisor and Adobe Champion

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_MahajanAutor

Level 2

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

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.

Cadastre-se

Fazer o login com rede social

Bem-vindo

Fazer o login com rede social

Verificando arquivo em busca de vírus

Este arquivo não pode ser baixado