Launch, grow, and unlock your career in data

October 12, 2018

Workout Wednesday: Top & Bottom Highlights

No comments
What a super useful workout this week from Ann Jackson! Get all of the requirements here. The idea was to build a dashboard that allows the user to highlight the top and bottom panes based on a set of options. There are so many use cases for this in a business setting.

The Easy Parts

  1. Creating the small multiples layout
  2. Limiting the data to 2017/2018. I chose to do this via a data source filter so that I didn't have to worry about adding the date field as a filter and add it to context.
  3. Creating the line chart
  4. Formatting the axis properly
  5. Creating the calculation needed for the shading (I approached it by doing one of the top calculations, then one of the bottom calculations, then the combined)
  6. Creating the total sales text at the top-center of the chart

The Biggest Challenge

  1. I knew I had to calculation right for the label for the latest month, but for the life of me I couldn't get it working. I felt like I needed another axis for the mark, then it dawned on me like a slap in the face how simple the solution is.

Here's a gif of the working solution. Click on the gif for the interactive version.

No comments

Post a Comment