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