Hi everyone,
I am looking for guidance on how to create a throughput report that displays the number of cases created vs the number of cases resolved, grouped by case type and customer for a given date range. Can anyone provide me with the steps to accomplish this task? Thank you in advance for your help!
@AK___
Hi Mate,
Step 1:- For this you need to create a report in Work class with columns 1. .pyID (Summarize =Count), 2. .pyStatusWork, 3. .pyLabel, please refer below image.
Step 2:- Add Filter for Date Range, Define Date Param’s in Parameters tab ( Here I have defined Fromdate and Todate as parameters of DateTime type.
Please find the output in below image
User can select the date range, number of cases created and the number of cases resolved and grouped by case type.
Hope it helps. Happy Learning !!
Thank you for the response. However, your report provides the results of total cases based on their status.
What I need is the number of cases created versus the number of cases resolved.
For example, today 500 cases were created, and 300 cases were completed (Resolved-Completed only).
@AK___
ok, I understood,
Case 1:-
But If you are trying to show that count in UI, then you have to create two RD’s with 1. pyID -Count and pyStatus= New 2. pyID -Count and pyStatus= Resolved. This RD can be referred in property and you can show the count in UI.
Case 2:-
If you are trying to show in a report, then there is no direct metod, but we can achieve with customized way. You can use the above same RD’s and Copy those results into New Data page properties individually by DT. This way we can show all the counts in a report with different status in single row.
Hope its helps, Happy Learning…!!
Thanks
Sudheer
I achieved the desired results after customizing the OOTB “pyWeeklyThroughput” RD.
