Custom Calculated Column Not Visible on Dashboard

[RGC9]

I’m experiencing an issue where a custom column I created in a report is not visible when the report is added to a dashboard.

The missing column is a calculated field defined directly in the report (not an actual table column). It displays perfectly in the report view, but when I add the report to a dashboard widget, the calculated column does not appear. 'Group by' & 'additional group by' are empty in my report. 

Has anyone encountered this behavior? Is there a way to make calculated fields visible on dashboards, or do I need to create a dictionary-level field or use another approach?

#reports #dashboards

Any guidance or best practices would be greatly appreciated.

[Ankur Bawiskar · Accepted solution]

@RGC9 

this is a known limitation such fields are not visible/available in dashboard

-> Dashboard widgets in ServiceNow are designed to display fields that exist as columns in the underlying table, not fields calculated at the report level 

-> Calculated fields in reports are not stored in the database and are only calculated when the report is rendered, which means they cannot be referenced by widgets or dashboards

Workaround:

-> create a custom calculated field at table level and populate it

-> then use this in dashboard

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[RGC9]

Thanks a lot Ankur!