Makeover Monday: Week29 | Paramaters

Makeover Monday; Week 29 - Lessons Learned | Parameters 


I.                What tripped me up this time; the sort…

It’s been awhile since I’ve created parameters,  so when I created the parameter, I forgot to put it in the sort and couldn’t figure out why it wouldn’t read the parameter; duh!.  Remember with Parameter’s.. 3 things; Make it: Use it; Show it! So how did that roll with this Viz

  • Make it; created the parameter to read

  •    Use It (in formula(s); Created 3 parameters with this formula; (Important; Not Important; Difference)

A/B. NOT IMPORTANT: (same for Important except what is in parens)

IF [Religious Importance] = 'Religion is very important'

THEN [Value]   END

 

C. Difference

{ FIXED [Country] : SUM([NOT IMPORTANT])-SUM([IMPORTANT]) }

Fixed tells Tableau to keep whatever is in brackets after the fixed the same even if you add/subtract something from the viz.  We want to country to stay constant.

 

D. Sort:

CASE [SORT PARAMETER]

WHEN 'NOT IMPORTANT' THEN [NOT IMPORTANT]

WHEN 'IMPORTANT' THEN [IMPORTANT]

WHEN 'DIFFERENCE' THEN [Difference]

END

  • Show it:

a.       Pulled it into the sort of the country;


Happy Paramatering! 

 

 

 

 

Comments

Post a Comment

Popular posts from this blog

How I secured my Tableau Specialist Certification

Image
I have been asked for input and resources in reference to securing my Tableau Specialist Certification, so I thought it would be best to write about it in a blog. I would register for this test NOW as the SPECIALIST cert if 50% off until the 1 st of the year (end of 2018).   You can register now and take it months later if you want.  Essentially, tools I used can be broken into these pieces; The hard part right now is the specialist cert is so new there are not a ton of resources for just the specialist but more of the Desktop Qualified Associate.   So hopefully this will help.    .        Classes    .        Resources           Prep for the certification I.Classes : I did not take any of the paid Tableau courses but did take several courses through Linkedin and Udemy. I like Udemy more just because I can go back any anytime an...
Read more

New Years; New ‘Goals:keeping up with the 'side gig'

Image
I am trying to get back into Tableau and keep my skills fresh while doing some other things with my career and job. So, getting back into Tableau had been fun, albeit a little time consuming. My goal is to publish every other week and absorb the MM webinars weekly.   This will give me a little breathing room for work while still keeping in the field.   I have been keeping up with the weeks but this is my first lessons learned post.  I hope to go back to the previous weeks and talk through lessons learned as time permits.  Week1 was a big struggle for me but a very fun one so stay tuned! MM_W5 , I really wanted to learn how to do a negative bar chart. This is in essence displaying a set of data in bar but show it against a colored background to help the reader understand the data visually against 100%.   I believe this has a stronger impact than just a standard bar chart.   Lessons Learned: Dual Axis; To do this type of chart you n...
Read more

MM_2019_W03 | Hex Maps | Adding Color Pallet | Highlight Bars in Chart

Image
Hex Maps | Adding Color Palette | Highlight Bars in Chart  This week we'll talk about these topics. How to do I go about approaching the topic and my direction. Lessons learned Resources How do I approach the Topic; Learn from others\refresher; I have to be honest, because I am so new to Tableau and want to learn as much as possible as I am working on my weekly viz's, I often look at others and see if something resonates with me.   Eva and Andy have been talking about keeping things simple lots lately so I try to focus on that when I look at other's viz's.   I also either try to pick at least 1 new learning lesson (easy to do at this stage) or something I haven't focused on for a while for a refresher. Sketch out what I am thinking ; yep, I try an jot down what I am thinking on paper. Many times it takes different directions but I think it's important to at least start wit...
Read more