Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Count unique visitors by day and sum over a week

DDelk
Level 1
Level 1

I want to count unique visitors each day, and then sum over the week. At present I have a unique visitor segment and I can do it by day/week/month etc. But if I count it by week it only counts a single visitor once, rather than the sum of the daily counts. So if a user visited 3 times in a week, I would see that each day. But the week total would not be 3, it would be 1.

 

I have tried a few calculations but I somehow need to count it by day then sum it across the week.

 

Can this be done?

 

Thanks

1 Reply
ForgotPassword4Times
Level 3
Level 3

What do you need to use the number for? Is it to total in a table or trend in a chart? One option would be to create a freeform table, use day as the dimension, evaluate a single week, and use the cumulative function with visits in a calculated metric. It should provide the correct column sum.