July 23, 2016
The Data School Gym - Slope Graphs with Vertical Lines
It’s my birthday, so what else would I be doing other than practicing Tableau and having a cold beer? I’m working on a project (more to come in a couple months) and needed a way to create vertical lines in slope graphs that are based on dimensions.
So here’s your challenge. Given this data set of fruit sales by region, build this slope graph. If you can’t access the data, email me and I’ll send it to you.
Some formatting tips:
- I used Avenir Next Condensed for the font - 18pt title, 12pt in the chart.
- The decreasing value is highlighted with color #E15759 and the increasing values are using #A5ACAF.
This was a fun little challenge for me. You’ll likely either get it immediately or get stuck. Upload your answer to Tableau Public and leave a link in the comments. Have fun! I need to get back to my Punk IPA.
Subscribe to:
Post Comments
(
Atom
)
Happy Birthday from @CharlieHTableau! I always struggle with these, but got closer than with the Eurovision challenge. I couldn't suss out the vertical dotted lines but will optimistically regard that as minor formatting. I wrestled with the labelling too - I *think* you probably just nest a combination of Fruit and Region in the calcs, but when I did that I lost the Slope and ended up with just dots. Enjoy your beer and I look forward to seeing the solution.
ReplyDeletehttps://public.tableau.com/profile/publish/DataGymSlope/Dashboard1#!/publish-confirm
Struggling with Vertical lines. I think it is based on a placeholder column (Maybe 0)
ReplyDeletehttp://imgur.com/a/PZcmu
Like Charlie, you are struggling with the part that led me to create the challenge. Here's a hint, think about how you can get Tableau to draw a vertical line. And it's not via annotations.
DeleteHmmm, I got the lines, but feel I cheated a little on the highlighting. Also couldn't get the highlighted line to sit above the non highlighted lines despite rearranging on the colour card. Good challenge though!
ReplyDeletehttps://public.tableau.com/profile/peter8354#!/vizhome/DSChallenge3/DSGymChallenge
Great work Petie! You figured out the hard part.
DeleteThis was fun! I got pretty far using the measure values and names cards, but can't figure out how to get the dotted line up the middle, so I'm thinking I might have done it differently? Also - does the highlight have to be LOD or did I overthink that?
ReplyDeletehttps://public.tableau.com/profile/patiekaige#!/vizhome/DSGRegionalFruitSales/RegionalFruitSales
Close Katie! The highlighting is not LOD. Not calcs at all actually. I'll post the solution tomorrow.
Deletehey Andy...how did you do the highlight...could u please post that?
DeleteJust started reading your blog. I very much enjoy your work, keep up the good work.
ReplyDeletehttps://public.tableau.com/profile/stephen.dziatkiewicz#!/vizhome/FruitSales_2/FruitSales
Great work Stephen!
Delete