Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Cumulative Totals and Deduping Unique Visitor

Avatar

Level 1

One of our teams currently has to create a date range every day when looking at Unique Visitors who have seen an experience.

eg

11/06/2018                 

11/06/2018 - 12/06/2018

11/06/2018 - 13/06/2018  etc

I created a cumulative calculated metric using Unique Visitors. The main difference between these approaches is the date range when used with UV de-duplicates the UV's and the cumulative metric does not.

Is there a way to create a calc metric to cumulate the totals AND dedupe so that the team doesn't have to spend so much time creating date ranges every day?

Thanks for any help

2 Replies

Avatar

Community Advisor

Dear T-Dubz,

Rather than using Unique Visitor try using Daily Unique Visitors Weekly Unique Visitors / Monthly Unique Visitors based on your requirement.

Thank You

Arun

Avatar

Employee Advisor

How about a custom date range with a start date that is static, then the end date range rolls daily?