Implementing custom Calculated Columns in Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 07:40 AM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 09:21 AM
Hi @amolpise
In standard reporting, it is not possible mate. It needs PA or write a good script (which is not a recommended case)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-07-2023 07:28 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2023 11:18 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 12:29 AM
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