In past blog posts I talked about the importance of blank shapes. In this blog article I review a couple of use cases for them! Holiday edition!
In an upcoming Data + Women New England Tableau User Group on December 12th at 11 am EST we are having an escape room session using Tableau Public dashboards. This idea is from Riya Mehta our moderator from the TUG group.
Did you know there are a lot of Tableau Public escape rooms? A neat one to note is from Mark Bradbourne here.
Use Case # 1
I created a Tableau Public dashboard for this session and used the Data + Movies data set . I pulled the holiday movies for Thanksgiving, Hanukkah, Kwanza, Christmas, and New Years with the help of fellow Tableau Ambassador David Kelly.
This escape room dashboard has questions with the help of parameters and a fun calculated field. A QR Code appears after the user has answered all of the questions! That QR Code will be active for our session! That QR Code has a blank shape when the questions aren't answered but appears after question 3 has been selected. See the video below for context.
This dashboard will be available for download after our session. Also the answers that are selected may or may not be the right answers!!!
How it works: I created a calculated field called Word for the possible selections from the Parameter questions. I used two words for this room and only one is the correct answer!
I then created a calculated field to use as a shape in a shape worksheet.
For the NULL values I used a blank shape. I used the QR Code shape for the other value.
Use Case # 2
In a Alteryx Training dashboard I created here I had an enemy appear when the progress bar equaled 100%. How did I do this? With a blank shape!
How it works: I used two calculated fields here. One for the course progress and one for the enemy pic.
Progress
STR(IF SUM([% Complete])>= .99 then 1
ELSEIF SUM([% Complete])< 1 then 0
END)
EnemyPic
ATTR([StarTrekLevel])+[Progress]
The EnemyPic calculated field combines the training level with a 1 or 0 value at the end of it, creating 10 different combinations!
Then in a floating worksheet I had the EnemyPic calculation on the Shape Marks card. It creates two images for every training level. I used a blank shape for any with a zero at the end.
On the dashboard you can see this floating worksheet.
Feel free to download this second dashboard and attend our session on December 12th!
Comments