MM_2019_W02: Heatmap and Viz inside Tooltip (more)|


Makeover Monday; week 2 was focused on Freedom of the press;

The viz this week is an  heat-map showing progression of data over 24 years by country and years using Viz inside of tooltip to show 2 different worksheets (see below)

Viz; 
 
Viz inside of Tooltip; essentially did 2 charts within the tooltip.
1st Chart Tooltip ; looked at the %age breakdown of the status for the time period using a table calculation which was % of total.

2nd Chart tooltip is a dual axis chart using a bar and a circle to indicate scores with the Sum (total Score) inside of the circle. The circles do not show (see end result below) because it is essentially just the sum (total score) as text and the status as color. 
So you get a comprehensive view just by clicking on the heat map box.
This is the syntax in the tooltip text pill;
Historic Press Freedom Split & Score 1994-2017 for <Country>
<Sheet name="Tooltip %'s" maxwidth="500" maxheight="350" filter="<Country>">
<Sheet name="Tooltip Bar Chart" maxwidth="600" maxheight="350" filter="<Country>">

Result;
 
 Stuggles;
Struggle 1/Lesson Learned: Viz inside of tooltip; view must be set to "Entire View"; otherwise you will get an error in your tooltip saying view is too large to show 

 
 


Struggle 2/Lesson Learned: cell size a little and found this to be able to play without having to drag
Drop with mouse; Format | Cell Size 



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