Here we go! This is the second installment of our new “dashboard series” that Erica started last week. My challenge will build upon what she built. If you participated last you can start from that there, if you haven’t started yet, you can check out her challenge here and then come back when you’re done…or if you’re looking for a starting point, then you can grab a copy of Erica’s workbook of her Tableau Public page.
But here’s my challenge – in my experience, when you create a scatterplot in a business dashboard, it is imperative that you also provide a view that gives context and detail because scatterplots can be confusing to many. So that’s what we’re going to do.
- Dashboard Size: 1050 x 650px
- 2 sheets
- In addition to last week’s scatterplot
- Add a bar chart that shows
- Selected State
- Any non-selected states in the reference box
- All non-selected states outside the reference box
- The outlier bar value(s) should be the aggregate median
- The bars should be sorted in this order
- Selected State
- Reference Box States
- Outlier States
- Match tooltips & formatting
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2022 in your description to make it searchable!
After you finish your workout, share on Twitter using the hashtag #WOW2022 and tag @LukeStanke, @_Lorna_Brown, @HipsterVizNinja, @_hughej, and @YetterDataViz
4 thoughts on “#WOW2022 | 06 | Adding Detail & Context”
Profit Ratio for Other (median) is an Avg value or aggregate median?
Hi Sarmistha, the Other (median) takes the aggregate median of all the remaining states.
How were you able to get the dynamic “Other (Median)” bar? I am struggling to figure that out! Thanks!
Hi Tori, there are a couple of different ways of doing it. Personally, I had to do two calculations: one for the dimension (to group all the other states into one row) and one for the measure (to make sure that the Other category was being aggregated by the median).
For more detailed solutions, you can download Sean’s workbook here https://public.tableau.com/app/profile/kcmillersean/viz/ContextualDetail/WOW20222Week6LetsaddContext
I’ll see if Sean has a video he can share too.