Implementing custom Calculated Columns in Reports

amolpise
Tera Contributor

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)

5 REPLIES 5

Dr Atul - LNG
Tera Patron

Hi @amolpise 

 

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

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
Tera Patron

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:

AndersBGS_0-1701933365887.png

AndersBGS_1-1701933432879.png

 

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

 

Best regards

Anders

 

 

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