2023-06-18 at 7:47 pm
#41030

Participant
Since the data structure is different from the dataset in the video, in order to show
1) Running sum and comparison, I calculate monthly daily column and running cumulative column beside them. For the sake of clarity I filtered only with Thailand as a country.
For comparison, I used cumulative of each country and percentage of each country
2) Running Delta, for the sake of clarity I filtered Thailand and sorted by date,
3) Drill Down and Date, 1st picture is top level drill down and 2nd picture is 2nd level drill down
4) Pivot Table , I compare Country vs Year and use heatmap in each column to easy see the highest number
5) Score Card,
6) Timeseries,
7) Bar chart,