Implementing custom Calculated Columns in Reports

[amolpise]

Hi All,

I have a requirement to introduce few calculated columns like age of active unresolved incidents and few others. This is for reporting purposes. I can see a configure function field while creating reports, but it accepts only existing table columns for calculation. 

For age of incidents, I would need Age = Current Date - Created Date

How do I achieve this in reports only? (no Performance Analytics is to be used)

[Dr Atul G- LNG]

Hi @amolpise 

In standard reporting, it is not possible mate. It needs PA or write a good script (which is not a recommended case)

[amolpise]

I found a solution to my requirement by utilizing the Incident_SLA database view. The "Actual_Elapsed_Time" field serves my purpose.

Best regards,

Amol

[AndersBGS]

Hi @amolpise ,

You cannot create current date - created date in the report designer. Instead what you can introduce, is to calculate MTTR etc. by utilizing function field. As an example below:

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

Best regards

Anders

[AndersBGS]

Hi @amolpise 

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

Best regards

Anders