Count unique visitors by day and sum over a week | Community
Skip to main content
D
DDelk
March 25, 2020
Solved

Count unique visitors by day and sum over a week

  • March 25, 2020
  • 1 reply
  • 2083 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ForgotPassword4Times

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

F
ForgotPassword4TimesAccepted solution
Level 4
March 31, 2020

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.

Terms & ConditionsAccessibility statement

Loading footer...