Launch, grow, and unlock your career in data

June 7, 2019

#WorkoutWednesday Week 23: Which sub-categories are ordered most?

No comments
I haven't done a Workout Wednesday in quite some time, in fact, this is the first one I have done this year. However, when I saw Curtis Harris' challenge this week (check it out here), I knew I wanted to give it a try. Why? Because it's a view that is very usable in a business context. I could certainly see this being used on a mobile phone in a real business.

  • Create a bar chart which displays the sub-category label on top of its bar
  • Label all bars to the right of the maximum value in view
  • Create a parameter that changes the display from a percent of total view to a raw order count view
  • Create a progress shadow for every bar
  • Show progress to 100% or progress to the maximum value depending on the parameter selection
  • Only use one sheet
  • Match formatting and colors
  • Match tooltips

The part that tripped me up the most was labeling the sub-category above the bar. I had done this before, but couldn't remember how, and I didn't to look back; I wanted to figure it out again. One other thing I wanted to do was make sure that the text didn't overlap the bar as it shows in the viz to rebuild (sorry Curtis, I know it's not 100% correct now).

To do this:
  1. Add Sub-Category on the rows twice.
  2. Hide the headers
  3. Turn on subtotals
  4. Move the column subtotals to the top
  5. Add a dummy measure as a secondary axis with the value 0
  6. Make sure the mark type is a circle on this shelf
  7. Add Sub-Category to the text shelf on the shelf with the circle and add an extra line below it in the text box with a space. This forces an extra line.

Tada! Fun one Curtis!

No comments

Post a Comment