This week’s #workoutwednesday was about building frequency matrix using color to represent the frequency intensity.
Requirements
- Use sub-categories
- Dashboard size is 1000 x 900; tiled; 1 sheet
- Distinctly count the number of orders that have purchases from both sub-categories
- Sort the categories from highest to lowest frequency
- White out when the sub-category matches and include the number of orders
- Calculate the average sales per order for each sub-category
- Identify in the tooltip the highest average spend per sub-category (see Phones & Tables)
- If it’s the highest average spend for both sub-categories, identify with a dot in the square
- Match formatting & tooltips – special emphasis on tooltip verbiage
This week uses the superstore dataset. You can get it here at data.world
Below is my attempt to meet the above requirements:
Thanks for reading 🙂
Do subscribe to blog for keep receiving updates