Creating a report with custom values

[brandongtr04]

Hello 
I am trying to create a report with values i calculated using a script

This is an example of the values i want to display in the report
Ticket: OTC0671, Open: 300 mins, WIP: 630 mins, PAR: 39619 mins, Closed Complete? NO, Total time in minutes: 40549, Greater than 1 hour? YES

The thing is, those fields are not present in the table and are not stored anywhere, i got them using a script that i am using in the filters and it is retrieving the tickets i need but i do not know how to display the rest of the data

Just to clarify i am not supposed to alter the original table so i can not add those fields to it

[Dr Atul G- LNG]

Hi @brandongtr04 

I believe the best approach is to use metrics based on state. Metrics will provide the duration between two state changes, and then you can sum them up to create a report from the metric tables

[Dr Atul G- LNG]

https://INSTANCENAME.service-now.com/now/nav/ui/classic/params/target/metric_definition_list.do%3Fsysparm_userpref_module%3D34d59794c0a808ae00b07de5452df889%26sysparm_clear_stack%3Dtrue