I hope everyone heard about workout Wednesday. Workout Wednesday a set of weekly challenges from Andy Kriebel and Emma Whyte (for 2017) and Rody Zakovich (for 2018) designed to test your knowledge of Tableau and help you kick on in your development.
I am writing this blog about a trick that I learned when I solved a workout Wednesday challenge of Week 39.
The requirement by Rody for this was
- Dashboard size: 1000 x 800
- Create a Parameters for metrics Sales|Profit|Quantity
- Create an Area Chart with a Line and Circle Marks for the Selected Metric over Month/Year of Order Date
- The Metric Selected must be Vertically displayed on the Y-Axis, this is dynamic based on the Metric Parameter, and is a single calculated field.
- DON’T HARD CODE THE LABELS! Think through what features Tableau offers that allow you to dynamically change/format strings
- Pay attention to White Space and weighing!
For me, the most challenging part was to create the vertical label. As per the requirement, I have first created a Parameter for the metrics Sales|Profit|Quantity
.
To use this parameter, I created a calculated field like this.
In order to label the selected parameter vertically, we need another calculated field. To create line breaks in tableau we can use char(10) function. Then I use mid function. Here I use 8 because quantity has 8 characters.
The next tricky part was to use 3 marks type- Line, Area chart and circle. To get the circle in the line I use an ASCII Symbol.
Here you go, this is my dashboard.
