This week’s #workoutwednesday by Rody Zakovich was about playing with dates. challenge was about comparing current period with previous period of same range of days.
Requirements:
- User can select a Start and End date for the Current Period
- The “Previous Period” contains the same number of days as the Current Period, and ends the Day before the Start Date
- Both the “Current” and “Previous” Periods must be on the same Date Axis (No dual Axis!)
- The Current Period must be distinguishable from the previous period
- Must show the Current Period Range, as well as, the Prior Period Range
This week data uses the superstore dataset
Here is my solution with the requirements given:
Thanks for visiting blog. Please do let me know your feedback and if any particular topic you would like me to write on.
Do subscribe to Tabvizexplorer.com to keep receive regular updates.