hi I have a table as shown below. I want to get the % of total for each status for previous 6 days. How do i write a query to get the same (% of total and also to query for previous 6 days).
DATE | A | B | C |
2021-05-19 | 14 | 33 | 123 |
2021-05-18 | 45 | 12 | 456 |
2021-05-17 | 4 | 6 | 213 |
2021-05-16 | 5 | 8 | 564 |
2021-05-15 | 4 | 9 | 987 |
2021-05-14 | 4 | 0 | 543 |