Hey all.
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?
Thanks for the thoughts. Workbook attached.
Hello John,
If a case statement utilized with a parameter is not providing the desired result, I suggest checking into a sheet selector/swapping option using a parameter. Some of the more interesting ones can be found here: Sheet Selection on Steroids. In addition, you might check out the examples in the Workbook & Calculation Library where many date/time examples have been documented by other customers
Patrick
Become a Viz Whiz on the Forums! Support the Community and master Tableau.