R. Luke DuBois shares his data enabled artwork. Word maps draw speech themes from US presidents and other historic figures. Words downloaded from online dating sites illustrate common moods of daters in major metro areas.
Check out my latest food themed dashboard built in Tableau! Compare American consumption averages to a USDA recommended benchmark. Find out the who and where of American over and under consumption.
Use the drop down filters to view the different food groups and population groups. The right most drop down filter changes the recommended intake reference lines by daily calorie intake level. Users can click on the colorful icons to filter the viz for each location or view a average. Hovering over the bars reveals tool tips with detailed information on the data including the metrics shown within the bar, the recommendation reference line, and the variance from the recommendation.
A few tricks went into the design and build of this dashboard that I would like to share with you. Below are some "how to" steps on the dropdown selector to change benchmark level for the reference lines, and the icon button filters.
How to create a dropdown selector to target a reference line
I wanted the benchmark calorie intake level to be a reference line on my viz, however I had 4 different benchmarks depending on which calorie intake level the user wanted to look at. So I created a parameter to act as a drop down selector that would target 4 different reference line benchmarks in my viz. This is how I created the dropdown parameter and connected it to the various benchmarks:
First I created a parameter called “Calorie Intake Level Parameter.”
Then I created a calculated field called “Calorie Intake Level Ref Line” that connected each level of the parameter to the benchmark calculations (the orange colored text indicates that is a data point). This is the calculation that I will use to display the reference lines.
I then added my new calculated field “Calorie Intake Level Ref Line” to my visual by dragging and dropping it onto the details mark then right clicking on my axis to “add a reference line.”
Once all set I showed the parameter as a dropdown selector on the dashboard by clicking on the down arrow in the right hand corner of the sheet.
About the Author