MM_2018_W52: Viz inside Tooltip | YOY Formula | Dual Axis reference Lines

This week I am breaking all the rules on Color Blindness!
NOTE: It is not advised to use Red & Greens in your viz's as it is very difficult for anyone who has color blindness to be able to read.  I decided to just go with the Christmas colors so I apologize to any color blind readers out there. Here is my final Viz;



What I learned this week;
1. how to put a viz in side a viz tooltip
2. how to do a formula that looks at a Year over Year comparison (YOY)
3. Struggled with a Dual axis reference line and doubling.

1. Tips of Viz inside of Viz; This is what I ended up with for the tooltip


This is what is inside of my tooltip; tricky thing here is that I formatted the sheet by size.

<Year>
Avg Spend: <SUM(Christmas spend in US$)> | YoY Change: <AGG(YoY Change)>

<Sheet name="Trend" maxwidth="400" maxheight="200" filter="">

2. Formula for YOY % ages. This is the formula I used for YOY comparisons to just look back at the previous year;  (ZN(SUM([Christmas spend in US$])) - LOOKUP(ZN(SUM([Christmas spend in US$])), -1)) / ABS(LOOKUP(ZN(SUM([Christmas spend in US$])), -1))

This is what the pieces of the formula are doing; 
ZN; if expression = Null then 0 else expression end

Lookup; LOOKUP(expression, [offset]); Returns the value of the expression in a target row, specified as a relative offset from the current row. If offset is omitted, the row to compare to can be set on the field menu. This function returns NULL if the target row cannot be determined. In the formula above, it is going back 1 row to the previous year.
/ is just calculating the %age

3. Dual Axis Reference Line; Initially I was going to use this viz:

It is just a dual axis basic barbell type chart.  But I didn't like it after I made it.  But one thing I learned was how to get the Average (762) line amount from NOT  replicating.  You have to Go into 'Format Reference Line' and change the alignment of the reference line label Hide 2nd reference line on dual axis to whatever you want (left, right, or center).  This seems to force the two labels to get stacked so it only looks like a single label.


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

Updated Vizual Resume - Resources/Tips-Tricks

Image
  Lessons Learned – Updating my Visual Resume – 2021 I made a New Year’s goal to update my resume since its been about 2 years and feel it is important to keep a resume up to date even if you are very happy in your current role.   Overall, it makes the task that much easier if you ever need to do it quickly and allows one to keep current in the field. Below are some tips on my inspiration, my approach and general tips/tricks. My Inspiration -           Lindsay Betzendahl; I really resonated with her resume and its simpleness and user friendly presentation. You will see some strong resemblances. -           Sites (there are lots of sources for visual resume’s in tableau but here is a start on some good links) o    https://public.tableau.com/en-us/s/interactive-resume-gallery o    https://www.tableau.com/about/blog/2019/8/bring-your-personality-and-skills-life-stand-out-interactive-resume o    https://community.storytellingwithdata.com/challenges/33aaaf72-34bc-47a4-bcf8
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