{"id":186,"date":"2024-04-23T21:06:06","date_gmt":"2024-04-24T04:06:06","guid":{"rendered":"https:\/\/sarahpallett.com\/?p=186"},"modified":"2024-04-26T15:20:34","modified_gmt":"2024-04-26T22:20:34","slug":"pep-talk-generator-life-is-hard-giving-yourself-a-pep-talk-doesnt-have-to-be","status":"publish","type":"post","link":"https:\/\/sarahpallett.com\/index.php\/2024\/04\/23\/pep-talk-generator-life-is-hard-giving-yourself-a-pep-talk-doesnt-have-to-be\/","title":{"rendered":"Pep Talk Generator: Life is hard, giving yourself a pep talk doesn\u2019t have to be."},"content":{"rendered":"\n

Growing up, my dad gave me the best pep talks. One of his favourties was \u201cKeep your stick on the ice.\u201d Not surprising given his lifelong love of hockey. My Dad passed in 2013, and I miss his pep talks. This pep talk generator helps to partially fill that void, and it is one way I can share the joy he found in lifting others up.<\/p>\n\n\n\n

So, let\u2019s get down to the Tableau part, shall we? Building this pep talk generator in Tableau required using a variety of Tableau techniques — here\u2019s a peek under the hood:<\/p>\n\n\n\n

Each pep talk is composed of four separate string values. This gives the dashboard over 100,000 possible pep talk combinations. To offer the choice between the create your own pep talk or randomly generated pep talk, I employed parameters & calculated fields. There are four string calculations for the create your own and another four calculations for the random version.  For those of you keeping score at home, that makes eight calculations.<\/p>\n\n\n\n

Pretty straight forward so far, agreed? Feel free to download the workbook from Tableau Public<\/a> and follow along if you wish!<\/p>\n\n\n\n

Both versions of the pep talk generator \u2013 create your own and randomly generated \u2013 use parameter values in the string calculations to change the text that is shown. Create your own has four parameters, one for each string calculation. Random also has four parameters, one for each string calculation. (Add 8 parameters to the score sheet!) However, the method by which these parameter values are updated differ. Let me explain:<\/p>\n\n\n\n

For the Create Your Own version, the values in the parameters are updated using Tableau\u2019s parameter control boxes, which are visible to the dashboard user.  In other words, when the dashboard user interacts with the parameter control box, the value in the parameter changes and updates the string calculation for that portion of the text.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

The randomized version also uses four parameters, one for each string calculation, however, these parameters update when the workbook is opened using a different set of calculations. The \u201cdefault when workbook opens\u201d calculations utilize the function RANDOM() to randomly assign a value between 1-18. <\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n
\n
\"\"<\/figure><\/div>\n\n\n

<\/p>\n\n\n\n

For those of you keeping score at home, we now have 12 calculations and 8 parameters. Could this be done with fewer calculations? Yes, probably. In fact you could combine the string calculations and thereby reduce the number of calculations, but I prefer having simpler, shorter syntax over nested calculations.<\/p>\n\n\n\n

Now that we have the mechanism by which both sets of string calculations will update, and we can use these calculations to build the sheets by placing them on the text marks card. I used two separate sheets, one for the create your own pep talk, and a second one for the random version. I also built two more sheets which I named \u201cbutton random\u201d and \u201cbutton create your own\u201d that are used on the dashboard to toggle between the two versions.<\/p>\n\n\n\n

You may be wondering how does the dashboard know which sheets to display? Dynamic Zone Visibility and Parameter Actions, FTW!  To employ these techniques, the dashboard utilizes another<\/em> parameter with two values: Random or Create Your Own, to identify the components needed for each version. The components are as follows: <\/p>\n\n\n\n

> four sheets: randomly generated text, create your own text, button random, button create your own <\/p>\n\n\n\n

and<\/p>\n\n\n\n

> four parameter control boxes that drive the create your own version <\/p>\n\n\n\n

On the dashboard, you must assign the \u201cControl visibility using value\u201d to each component, or in the case of the parameter control boxes, the container that holds the components. Lastly, parameter actions drive these components (aka zones) to update dynamically when the dashboard viewer clicks on the \u201cbutton\u201d sheets. Naturally, there are a few more calculations needed to achieve this functionally, as well calculations for formatting the tooltips \u2013 all in, the total number is 22 calculations and 9 parameters! It sounds like a lot, but with consistent naming and a well-laid out plan, the dashboard build is very do-able.<\/p>\n\n\n\n

I hope this Pep Talk Generator lifts you up and gives you the motivation to keep going. And if you know someone that needs a pep talk, please pass it on. http:\/\/tinyurl.com\/peptalkgenerator<\/a><\/p>\n\n\n\n