October 12, 2018
Workout Wednesday: Top & Bottom Highlights
area chart
,
highlight
,
labels
,
level of detail
,
line chart
,
LOD
,
parameter
,
small multiples
,
table calc
,
Workout Wednesday
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
- Creating the small multiples layout
- 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.
- Creating the line chart
- Formatting the axis properly
- 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)
- Creating the total sales text at the top-center of the chart
The Biggest Challenge
- 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.
Subscribe to:
Post Comments
(
Atom
)
No comments
Post a Comment