I have 2 tables: Date and Cases which is daily detail of the cases coming in daily.
I would like a simple line chart to show weekly comparison with the past 7 days and a line comparing the previous 7 days.
This would be whatever I'm measuring-total cases opened, closed, by team, closure time, etc.
Need help with the measures to do this, nothing I'm trying is working. Someone previously gave me total for prev week but this is not what I needed. I wanted daily (like below).
| Date | Case closure time (days) this week | Case closure time (days) previous Week |
| Saturday, October 27, 2018 | 5 | |
| Sunday, October 28, 2018 | 6 | |
| Monday, October 29, 2018 | 8 | |
| Tuesday, October 30, 2018 | 4 | |
| Wednesday, October 31, 2018 | 5 | |
| Thursday, November 1, 2018 | 3 | |
| Friday, November 2, 2018 | 2 | |
| Saturday, November 3, 2018 | 32 | 5 |
| Sunday, November 4, 2018 | 24 | 6 |
| Monday, November 5, 2018 | 19 | 8 |
| Tuesday, November 6, 2018 | 80 | 4 |
| Wednesday, November 7, 2018 | 50 | 5 |
| Thursday, November 8, 2018 | 54 | 3 |
| Friday, November 9, 2018 | 43 | 2 |
| Saturday, November 10, 2018 | 1 | 32 |
| Sunday, November 11, 2018 | 2 | 24 |
| Monday, November 12, 2018 | 3 | 19 |
| Tuesday, November 13, 2018 | 1 | 80 |
| Wednesday, November 14, 2018 | | 50 |
| Thursday, November 15, 2018 | | 54 |
| Friday, November 16, 2018 | | 43 |
| Saturday, November 17, 2018 | | 1 |
| Sunday, November 18, 2018 | | 2 |
| Monday, November 19, 2018 | | 3 |
| Tuesday, November 20, 2018 | | 1 |
