Expand my Community achievements bar.

Check out the November edition of the Analytics Community Lens newsletter to see what's been trending in the last two months!

Cumulative Totals and Deduping Unique Visitor


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.



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


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



Employee Advisor

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