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,

