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 and review those where Linkedin wants you to be a premium member to view the classes. Below you will see the courses, but I do not think you
Read more

Dream Job & Fit Body/Mind

Image
  Reflection on my last year! How I found my dream job (for a dream company) and physically & mentally feel the best I have in many years if not my life?   This blog is out of traditional context or the typical purposes of my blog as I reflect on my today on my birthday.   Because I am about to enter a dream job with a dream company , I thought it might be beneficial to talk a little on the ‘how’ in my journey.   A lot of this had to do with having extra time during covid while also owning my direction during this extra time.   Because our social lives were shut down, I found myself embracing two significant pieces in my life that I wanted to own more.   The first being jumping into Reporting and Tableau Analytics and the second being fitness.   I will talk to both during this excerpt as I believe both are intertwined. THE JOB: Two weeks ago, I was offered, a dream job; A Senior Reporting and Analytics Role at Workday.   It is not Tableau focused but my skills/experience
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