Formula Indicator to add 30 mins

Raaj Kumar1
Tera Contributor

Hi, I have an automated indicator that collects data from a duration field. I have a widget in the dashboard with a time series that works perfectly on this indicator.  Now we have a requirement that I need to add 30 minutes extra on the duration field. example - Duration = 1 hour 30 Minutes but I need 2 Hours. Is it possible in PA or should I create a new field in the table and setup some functionality to do it?

PA.PNG

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

Please explain your usecase. You have a duration field. So you are measuring from time a to time b and that difference is in your field. 

What is that 30 minutes for? If it's like setting limits or something like that, it's not going to work in just PA.

 

You are reporting on a Max of hours. Is there anything in that indicator that is calculated? Because then you could try to see if you can add 30 minutes through the calculation, but I can't think of any reason why you want to do that. But since it's only one thing you are showing (the max), it would just be that value + 30 minutes (again: while I am typing it, it's making even less sense to me).

Whatever your use case is, I think the best thing would be to create a new field, but also for that, I am missing information to find any logic behind it.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

2 REPLIES 2

Slava Savitsky
Giga Sage

In your automated indicator, you can select Scripted checkbox and reference a script that would perform the needed calculation in the Script field. For detailed information about scripting in Performance Analytics, have a look at this article from the product documentation.

Mark Manders
Mega Patron

Please explain your usecase. You have a duration field. So you are measuring from time a to time b and that difference is in your field. 

What is that 30 minutes for? If it's like setting limits or something like that, it's not going to work in just PA.

 

You are reporting on a Max of hours. Is there anything in that indicator that is calculated? Because then you could try to see if you can add 30 minutes through the calculation, but I can't think of any reason why you want to do that. But since it's only one thing you are showing (the max), it would just be that value + 30 minutes (again: while I am typing it, it's making even less sense to me).

Whatever your use case is, I think the best thing would be to create a new field, but also for that, I am missing information to find any logic behind it.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark