2020 Update; 2020_Week 14: lessons Learned

I've been a bit remiss in talking through what I am learning on a weekly basis.. so getting back to it after being diligent about doing Viz's every week this year.

2020_Week 14: lessons Learned

1. A few things about the formulas in the viz;

a.       Most Recent Year;

see Data below: varied per country: single and double digit numbers

b.   Formula to Fix data; {FIXED [Country]: max ([Year]) }

2.       Created Dual Axis, Scatter Plot to look at Average Paid/Unpaid work

 

a.       True/False Filter to only pull the most recent year in the data, since I am just taking the averages.

Formula: zn ([Year]) = zn ([Most Recent Year]

  3. Categorizing Time Use: Paid/Unpaid Work hours

a.       Formulas;

                                                               i.      Paid Work Hours: if [Time use] = 'Paid and subsistence work' then [Average Time (hours)] end

                                                             ii.      Unpaid work Hours: if [Time use] = 'Unpaid domestic, care and volunteer work' then [Average Time (hours)] END

Data: 

 

1.       4. Added Level of Detail for Scatter plot chart

5.5. Added Trend Line to show the Average of Unpaid workers

 

1.     6.   Formatting type things;

a.       Title; used power point again as it allows the most flexability in the fonts without having to make sure the administrator server has the font when downloaded.  Just copy as a picture

b.       Learned how to add a | as a separator. All it is is a | mark with a crazy big size font.

c.       Big Numbers on what the data is telling you.  I always like to paint exactly what the user should know/see from the question in my title (so answer the question)

d.       In scatter plots, I always like to point out the high and lows in the data. Again, lead the reader.

e.       If you have a line in your graph, point out what that line it as I can never assume the reader knows what that line represents.