MM_Week24; Basic chart drawing the reader to my points


Here is a little background on the above chart and some background on some of the things I had to think a bit about as I built.  Tableau Public Viz


·         Year Change (
o   FORMULA: FLOAT(LEFT([Year],4))
o   What it does; year was combined like this; 2018/2019 so the formulas took the last 4 digits of the year
·         Formula for Boys/Girls difference Since 2002
o   FORMULA; (ZN(SUM([Girls Participation])) - LOOKUP(ZN(SUM([Girls Participation])), FIRST())) / ABS(LOOKUP(ZN(SUM([Girls Participation])), FIRST()))
o   What it does; took the numbers and evaluated the comparison from 2003 to the next year always going back to 2003.
o   Pieces of the formula;
§  ZN; ZN tests to see if a function is null, and if it is, it will return a value of zero
§  Lookup; LOOKUP function that allows you to look up and down a partition of rows and return the value in that field by specifying an offset. In the formulas example, we are looking up the FIRST Value
§  ABS; This function returns the absolute value of the specified number.
o   Data:


·         Boys Soccer Change Formula (must group sport first)
o   IF ATTR([YEAR])=2018 AND ATTR([Sport (group)])='Soccer' THEN [Girls Difference Since 2002 ] END
·         What is does: helps with this formula that it ONLY attached to the Soccer attribute so it can be isolated by itself. (NOTE the Track and Field does not have a # associated to it so we can point the reader to the one attribute)

 
·         SPACER
Formula: IF ATTR([YEAR])=2018 AND ATTR([SPORT])='Soccer' THEN ' | ' END
What it does: only displays a | if it passes 2018/Soccer sport

·         I then manually created some sets for my top 5 sports
·         Global Format on Girls/Boys Soccer Change; +0.0%;-0.0%
·         Added ATTR(Year) (delivered year); ATTR([Year]) to  DETAILS
o   What is Does: Drop a dimension on Detail on the Marks card to separate the marks in a data view according to the members of a dimension. Unlike dropping a dimension on the Rows or Columns shelf, dropping it on Detail on the Marks card is a way to show more data without changing the table structure.
o   Without the Year on the Marks – Detail card;
 
o   This is what is looks like added (so I’ve allowed to change the most granular place where an analysis takes place)
 
·         Label (at ends to only show top)

TEXT:  <SPORT><AGG(SPACER)><AGG(BOYS SOCCER CHANGE)>
What it does: displays sport the | (if 2018 and soccer) and the Soccer change (if 2018 and Soccer); else null

All other items are just formatting things.

Thanks for reading.. hope it helped!

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