This week’s #workoutwednesday was about creating small multiple grids to use the char() function extended to use unicode characters.
Requirements
- Create 1 sheet with a Small Multiple of 20X5 Grids for each Sub-Category in Office Supplies
- The percent of Total segment starts from the Bottom Right.
- The Sub-Category name needs to be above the Grid, with the Percent of Total
- Dashboard is 800X800
- YOU CAN ONLY USE THE TEXT MARK. NO BLENDING, NO SQUARES, JUST TEXT.
My attempt to create the chart as per requirement:
Here’s the steps I did to re-create the dashboard shared:
Step 1: Import the super store data into Tableau and created 2 calculated field named rows & columns as shown in screen shots (taken from hint given on Andy’s post):
Step 2: Drag row into rows shelf and columns in column shelf then apply context filter on “Office supplies” categories.
Step 3: Drag sub-categories to text label in Marks area and sort the data by sales then for both rows & columns compute using –> sub-category. Next is to perform the calculation into discrete mode for both rows & columns
Step 4: Create a calculated field “% of total” using below formula:
Next is to create calculated field “Circle”
Now create calculated field “block” to create line break in field:
Step 5: Next is to finally create last 2 calculated field named Right and Left to show circles on the chart as required:
Left:
Right:
Step 6: Drag % of total, left and right into Marks shelf and adjust the screen view to entire view:
Now, format the Label text as below:
Hope you enjoyed the post 🙂
Thank you!
Do subscribe to blog for new interesting posts