MM_2019_W7 | Makeover Monday : Calendar | Highlight Bar Chart | Stay away from Opinions!



This week's dataset was very fun! It was on Trump's time that is spent on Executive time.  Weather you live in the US or elsewhere.. I think this dataset was fun for most.  So.. Lessons learned.

From the #MMVizReview; the biggest take away I learned was do NOT let your political opinions surface in your Viz.  Andy reprimanded many of us for showing how we feel about the current president.  From a professional perspective, we need to just ask the question or state the facts without showing bias or opinions one way or another (as hard as this may be these days).

Here are some design take away' s.
  1. Calendar; doing the calendar was fun.  I really liked being able to do a calendar without the Sat\Sunday because there was no data in those days and I didn't want to fill up the space with those days.  Chandra McRae was my inspiration on this one.
    1. Formulas;
      1. Took data and pulled Month from it;  DATENAME('month', [Date])
      2. Difference between Weeks and Minimum number of weeks to have the rows display as calendar;
        1. Diff between W and Min W; [Week] - [Min # of Weeks]
          1. [week] (no formula needed)
          2. [Min # of Weeks]; { FIXED MONTH([Date]): MIN([Week])}



  1. Line chart with Highlights, annotations and helpful tooltips.


  1. Highlight; I just highlighted the Executive time in the color and made all the others gray.
  2. Tooltip;

<DAY(Date)>
<ATTR(Top Category)> | <% of Total SUM(Hours % of Total)> of hours for day | <SUM(Total Hours)> total hours

<% of Total SUM(Hours % of Total)> of hours for day Formula; [Hours Part]/[Total Hours]
Hours Part; DATEPART('hour', [Duration])
Total Hours; [Total Seconds]/3600

There is a table calculations on the Hours % of Total (2nd part of the tooltip)
 

The rest was just formatting.

Also in the viz review this week; the first 20 minutes or so, Andy was NOT doing a screen share and you had to follow on twitter as he was without Eva and no one was watching comments.  His demonstration focused on making a calendar, but a little different than mine.
Interactive Viz

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