Performance analytics report is showing the data for the month to which record does not exists

kpn
Tera Contributor

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. 

kpn_0-1748618766792.png

 

0 REPLIES 0