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

Report Builder

Avatar

Level 1

Hi All,

I want to create a 6 weeks avg report which shows day wise data. For eg: I want to show previous 6 weeks Monday data in one worksheet and previous 6 weeks avg Tuesday data in another worksheet. 

 

I used rolling data and used custom date range as well, but as the weekly rolling data shows for 7 days once, the second week's data changes its day. 

 

Eg: I am displaying data from 11th April 2022. Technically I want the next week Monday date to be 18th April. But due to the weekly rolling dates, I am getting 17th April in the Monday worksheet. But 17th is Sunday. I am attaching the trend from Report Builder for your reference

hshilps221_0-1653120717672.png

 

 

Could Someone please advise?

 

Regards,

Shilpa

0 Replies