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

Single Day Historical Report

I-5
Level 2
Level 2

How can I create a report that compares visits for every Sunday (only Sunday) for the past 6 months?

1 Accepted Solution
vibhatna
Correct answer by
Level 5
Level 5

@I-5 ,

If you are using Analysis workspace, you can create a report based on Day of Week dimension and you will see Sunday as a line item, now breakdown Sunday with Week dimension, it will give you all the Sunday Visits based on your Date range. 

vibhatna_0-1625077730098.png

I have verified this and it is providing only Sunday visit on Week breakdown. You can also check.

View solution in original post

0 Replies
vibhatna
Correct answer by
Level 5
Level 5

@I-5 ,

If you are using Analysis workspace, you can create a report based on Day of Week dimension and you will see Sunday as a line item, now breakdown Sunday with Week dimension, it will give you all the Sunday Visits based on your Date range. 

vibhatna_0-1625077730098.png

I have verified this and it is providing only Sunday visit on Week breakdown. You can also check.

View solution in original post

I-5
Level 2
Level 2
Worked exactly like I wanted. Great answer, Thank you.