We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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