Discussion
Wellsfargo
IN
Last activity: 11 Apr 2015 3:42 EDT
Average number of tasks created in particular month
i have a rquirement to dispaly average nubmer of tasks created in particular month . this should be done in pega 7.1.6 . i font find any customization in report definition ..
Can any one help me out ???
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Pegasystems Inc.
US
Hi,
If by "tasks" you mean "Cases" then you can customize the OOTB "Throughput in past week by work type" report (DesignerStudio > Reporting > Access > Report Browser > Monitor Processes > Throughput in past week by work type) to generate the same or similar results for the last month.
If by "tasks" you mean "Assignments" then you can customize the OOTB “External Assignments by Operator” report (DesignerStudio > Reporting > Access > Report Browser> Monitor Assignments > External Assignments by Operator) to generate the same or similar results for the last month.
Regards,
Henry
Pega Academy
Wellsfargo
IN
Thanks henry ... my requirement is need to calulate average tasks per month .. can this be possible ...??
Pegasystems Inc.
US
Hi,
Yes, it can be done; it all depends on how you define what a "task" is. When you say "tasks" do you mean PRPC "Assignments" or PRPC "Cases" or PRPC "SubCases" something else? Once you can translate your understanding of a "task" to a corresponding PRPC instance then you should be able to easily calculate their averages based on other criteria.
Regards,
Henry
Pega Academy
Wellsfargo
IN
here task is work object (Case id ) . i can say i need to caclculate average of pyID (cases created in particular month)...it should be like how many cases created for a particular day ..
Let me give example like
There are 20 cases created in Jan then my average woulb be 20 /31(number of days in jan) =0.66 cases per day
20 cases creatred in Feb then it would be 20 /28 (29 based or year lealp or non leap) =0.71 cases per day
Pegasystems Inc.
US
Hi,
Yes, you can easily create a Summary Report that generates these Averages. You will need as many as four columns in your report. The first column would be ".pyLabel" as the Column Source (make sure pyLabel it is set to the Case Type for every Case. The second column in the Summary Report would be ".pyID" as the Column Source and "COUNT" as the Summarize option. The third column would be a computed column using functions which calculate the number of days in a given month. The fourth column would also be a computed column that divides the COUNT of cases by the number of days to compute the average. You will have to group the results by month using the ".pyResolvedTimestamp" column.
Regards,
Henry
Pega Academy
Wellsfargo
IN
i was looking for "The fourth column would also be a computed column that divides the COUNT of cases by the number of days to compute the average. You will have to group the results by month using the ".pyResolvedTimestamp" column." ..am not understaind how to do this in report definiation ...average function is displying only for integer property type ...
here should i calculate average by using pega' Avg function or need to customize in customized functction ???