Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - show previous weeks

Hello,

I'm putting together a report where I need to select a week or dayand be able to compare this to the previous 4 weeks before that.

How can I do this and can I see that in the same graphic?


Thanks!

1 Reply
MK_QSL
MVP
MVP

Current Week

Sum({<Date = {">=$(=Date(WeekStart(Today())))<=$(=Date(WeekEnd(Today())))"}>}Sales)

Last Week

Sum({<Date = {">=$(=Date(WeekStart(Today())-7))<=$(=Date(WeekEnd(Today())-7))"}>}Sales)

For 4 Week adjust accordingly...