Track how many cases were still open (WIP) in each month, broken down by how long they have been open.
X-axis: Month (Last 12 month)
Y-axis:
<60 days ---> Cases assigned and not closed during that month, with opened date should be less than 60 days ago
>=60 days ---> Same but open days was 60 or more days ago
1. For each month get all cases that were open during that month
2. Calculate age (today-opened date) for those still opened at the end of that month
3. Group by <60 and 60+ days
How to achieve this using PA?
This the graph I am able to achieve in which I am getting same data for older months.
