Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sravanthi Muralidharan (SravanthiM2905)
Anthem, Inc.

Anthem, Inc.
US
SravanthiM2905 Member since 2017 5 posts
Anthem, Inc.
Posted: Sep 22, 2022
Last activity: Sep 23, 2022
Posted: 22 Sep 2022 16:45 EDT
Last activity: 23 Sep 2022 10:29 EDT
Closed

get the sum of difference in time taken in minutes between pxcreatedatetime and pxsavedatetime

I need to get the sum of time difference taken between pxcreatedatetime and pxsavedatetime for each case in a report to calculate the time taken to process all the cases in a day.

 

I am able to get the difference in minutes, but getting the sum is giving wrong values. Any suggestions to approach this in a report definition is appreciated. 

***Edited by Moderator: Pooja Gadige to add capability tags***
To see attachments, please log in.
Pega Platform 8.6
Reporting
Low-Code App Development

Posted: 2 years ago
Posted: 22 Sep 2022 20:55 EDT
Dipti Aggarwal (Dipti Aggarwal)
PEGA
Senior Engineer, Technical Support - User and Product Experience
Pegasystems Inc.
IN

Hi @SravanthiM2905 ,

You can refer to this thread to check the configuration required to show the sum of values in a report definition.

https://support.pega.com/question/need-show-total-column-report-definition

Let me know if it helps!

Thanks

Dipti Aggarwal

 

To see attachments, please log in.
Posted: 2 years ago
Posted: 22 Sep 2022 21:46 EDT
Aruldevan Thangappan T (ArulDevan)
NCS Pte. Ltd
Aruldevan Thangappan T
NCS Pte. Ltd
SG

Hi @SravanthiM2905: When you say the sum is showing wrong values, are you measuring manually in seconds and comparing with PEGA? If this is the case, it wont work in PEGA. Difference in minutes will not consider the seconds. Lets say a case is completed within same minute, the output of difference in minutes will be 0. If the case is created at 1:15:58 and resolved by 1:16:01, the output will be 1. Further the sum will work accordingly.

If this is your issue, try to create a new function to calculate difference in seconds. Refer this for creating new function. https://support.pega.com/question/datetime-difference-function-report-definition

Thanks

To see attachments, please log in.
Posted: 2 years ago
Posted: 23 Sep 2022 10:29 EDT
Sravanthi Muralidharan (SravanthiM2905)
Anthem, Inc.

Anthem, Inc.
US

Hi @ArulDevan,

Thanks for your response.

My scenario is little different. I am using sub report to calculate the difference as I need to get the min value of pxcreatedatetime and max value of pxsavedatetime to find out the first commit and last commit based on primary key of the table. When I do this with sub-report, i am getting count of records rather than the sum. For Example, attached screenshot DifferenceinMinutes gives me the difference in minutes for individual batch. When I apply the sum to the difference, it's giving count of records based on the join applied on the sub-report(attached screenshot SumofMinutes).

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice