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

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