My goal here is to create a parameter that shows several date options compared to their previous counterparts. Such as Week over previous week, last 2 weeks compared to the 2 weeks before etc. My data updates every day and I exclude Today. This would be simple enough for a static report type situation, but am looking for dynamic filters/parameters.
You can see in the screenshot:
I am also using some table calcs. Current period, previous period, % difference.
Is this something you recommend and is possible/sturdy enough to implement in an automatic daily report?