Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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