This week’s #workoutwednesday was about comparing last 2 periods sales for a sub-category using date functions with customize tooltips.
Requirements
- Dashboard size should be 600×700.
- The Change field should be displayed as a number, not a string.
- Sub-Category should be sorted ascending by Change.
- Tooltips should match exactly.
- Prior Month and Most Recent Month should always be matching days, for example: If the max order date is 6/15/2017: the most recent month range should be orders between 6/1/2017-6/15/2017 and the prior month range should be 5/1/2017-5/15/2017.
- Make sure your audience knows the dates in question by providing a note about the date ranges above the viz, and make sure that the date range displays match the colors of the dots in the viz..
- Display the x-axis on top of the viz, and use the traditional x-axis space for a color legend.
- Show the mark label on hover *for the most recent month only*. If the value for the most recent month is *lower* than the prior month, the mark label should be displayed to the left of the dot. If the value for the most recent month is *higher* than the prior month, the mark label should be displayed to the right of the dot.
Below is my attempt to meet the above requirements:
Thanks for reading 🙂
Do subscribe to blog for keep receiving updates