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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Count unique visitors by day and sum over a week

Avatar

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 Accepted Solution

Avatar

Correct answer by
Level 4

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

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.