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

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.
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.

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.