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])}

2. 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