PA script to calculate summed duration between two fields

[ujjwala_678]

Hello Experts,

I am working on a dashboard and need to create a PA widget which will represent average resolution time - this will be  difference between two fields ....

I am a newbie to PA topic ... Could anyone please guide me on how to write script for this.. 

As per the requirement, I have to use formula indicator for this, 

I have created two automated indicators 

One is to calculate summed duration 

And another to calculate total number of records present in the system 

Avg=summed duration/total number of records

Thank you in advance! 

Ujjwala 

[AndersBGS]

Hi @ujjwala_678 ,

If you have the automated indicator with summed duration and the automated indicator with number of records, then you just need to create a formula indicator with the calculation summed duration divided with count if tickets. No PA script is needed here. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders - https://www.linkedin.com/in/andersskovbjerg/

[ujjwala_678]

hello @AndersBGS ,

Thanks for replying ....yes I am looking to have something like that...

But for automated indicator which is calculating sum as the difference between two fields there I have to provide script which will calculate the difference between two fields and will return the summed value

Thanks,