Hi,
I have a table similar to this:
Country, total, recovered, death, date
USA, 30000, 2000, 1000, 3/3/22
Italy, 25000, 1500, 750, 3/3/22
UK, 20000, 1000, 500, 3/3/22
USA, 25000, 1500, 750, 3/3/21
Italy, 20000, 1000, 500, 3/3/21
UK, 15000, 1000, 500, 3/3/21
USA, 20000, 1000, 500, 3/3/20
Italy, 15000, 1000, 500, 3/3/20
UK, 10000, 500, 200, 3/3/20
Do I have to restructure it like this:
USA_total, USA_recovered, USA_death, Italy_total, Italy_recovered, Italy_death, UK_total, UK_recovered, UK_death, date
30000, 2000, 1000, 25000, 1500, 750, 20000, 1000, 500 3/3/22
25000, 1500, 750, 20000, 1000, 500, 15000, 1000, 500 3/3/21
20000, 1000, 500, 15000, 1000, 500, 10000, 500, 200 3/3/20
in order to get a single graph for “Total” that shows all countries in one graph and similarly for recovered and deaths?