This week we will be looking at Sub-Category Sales by Month, and creating a highlight table of which sub-categories were the Max and Min Sales in that Month.
Requirements
Requirements
- Sub-Categories are sorted in Descending order by Total Sales in the Year
- Each Month will Highlight the MIN Sales in Red, Max Sales in Blue.
- Pay attention to formatting and how the Table adjusts in size according to how many Sub-Categories are being shown
- Allow users to Filter by Year and/or Category
As you complete this example, feel free to share on Twitter using the #WorkoutWednesday hashtag. Don’t forget to tag @RodyZakovich, and @LukeStanke. We really want to see your work.
Also, if you want your efforts throughout 2018 tracked, feel free to fill out this Google Form.
Good luck!
Hi Rody,
Here’s my WW visualization:
https://public.tableau.com/views/MaxandMinsalebyMonth/Dashboard1?:embed=y&:useGuest=true&:display_count=yes
@RodyZakovich
Hi,
I achieve background color formatting but stuck with the condition formatting of labels.
Achieved it. Thanks.
My attempt for this week:
https://public.tableau.com/profile/varun7577#!/vizhome/MAXANDMINSalesbyMonth/WOW-Feb14
Hi Guys,
here’s my version!
https://public.tableau.com/profile/marcodegola#!/vizhome/WorkoutWednesday2018/2018w07-ww?publish=yes
This was interesting!!
DISCOVERED NOTIONS:
_ how to extend color to totals
_ (incredibly) how to make a colored table
LEARNED NOTIONS:
_ how to simplify all without LOD expressions
_ IFNULL + aggregation in order to make null values to appear
_ Blank and fitting of the dashboard
Thank you so much!
Hi Rody,
Thanks for sharing! My late version:
https://public.tableau.com/profile/sisi.yu#!/vizhome/VizMaxandMinsalesbymonths/Dashboard1
It’s interesting to find that ifnull doesn’t work sales but aggregation sum(sales).
And here’s mine 🙂
https://public.tableau.com/profile/kinga6658#!/vizhome/Week7RodyMinandMaxSalesbyMonth/MAXandMINSalesbyMonth?publish=yes
Fun practice – https://public.tableau.com/views/WOW2018-Week7-MinandMaxSalesbyMonth/MINandMaxSalesbyMonth?:language=en-US&:display_count=n&:origin=viz_share_link