Skip to main content
Bhushan_Mahajan
Level 2
July 31, 2024
Resuelto

Daily average Unique Visitors Calculated Metric

  • July 31, 2024
  • 3 respuestas
  • 1832 visualizaciones

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 tema ha sido cerrado para respuestas.
Mejor respuesta de 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/

3 respuestas

Isha Gupta
Adobe Champion, Community Advisor, UG Leader
Isha GuptaAdobe Champion, Community Advisor, UG LeaderRespuesta
Adobe Champion, Community Advisor, UG Leader
July 31, 2024

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_Mahajan
Level 2
July 31, 2024

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
Community Advisor
July 31, 2024

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.