2

Have a table based on Covid-19 data from the Department of Health (UK).

enter image description here

So far so nice. But I want to create an extra column for the percentage change. I am still learning. I'll add the data although it has been modified - there is a question about how I did that in Pandas. How to transform data in Pandas with categoricals and timestamps for use in tableau

Update

I know I have to switch year data to create column.

Type 1 Acute?   NHS England Region  Code    Name    Date    Value
0   No  East of England 8D379   CARETECH COMMUNITY SERVICES LTD 2020-08-01  0.0
1   No  East of England 8D379   CARETECH COMMUNITY SERVICES LTD 2020-08-02  0.0
2   No  East of England 8D379   CARETECH COMMUNITY SERVICES LTD 2020-08-03  0.0
3   No  East of England 8D379   CARETECH COMMUNITY SERVICES LTD 2020-08-04  0.0
4   No  East of England 8D379   CARETECH COMMUNITY SERVICES LTD 2020-08-05  0.0

I tried this combination. Would be too confusing for most people...

enter image description here

halfer
  • 19,824
  • 17
  • 99
  • 186
elksie5000
  • 7,084
  • 12
  • 57
  • 87

1 Answers1

0

Any analysis in Tableau can be expressed in terms of percentages. For example, rather than viewing sales for every product, you might want to view each product’s sales as a percentage of the total sales for all products.

Read about % change

Debayan
  • 572
  • 6
  • 16