Calculated Column/Field in report

Sana18
Kilo Contributor

Hi

I am new to Servicenow and creating a report where I have to create two calculated columns:

1. Last Compliance Date + 1 Year to get next compliance date

2. Number of days to this next compliance date

Is it possible to define these columns anywhere like you do in any other reporting/analytics tool (Power BI or Tableau).

Also, what access do I need in order to do so.

 

Any help is much appreciated.

 

Regards,

Sana

 

12 REPLIES 12

sachin_namjoshi
Kilo Patron
Kilo Patron

You will need to create custom columns and configure business rule to update values in these columns based on your requirements.

 

Check Create Columns for steps to create column.

I will recommended to complete NOW learning courses.

 

https://developer.servicenow.com/dev.do#!/learn/learning-plans/paris/new_to_servicenow

 

Regards,

Sachin

Hi Sachin!  While I'm an expert in SQL report development, which is an unlimited technology, I'm still learning a lot about SNOW's basic limited reporting platform.  I'm having the same issue - I need to add a calculated column - however when I create a report or attempt to modify a report I can't find where I can create and add the calculated column.  In my use case - my report shows an incident backlog by Classification and Module.  However sometimes the module name is empty.  I want the calculated system to be "Classification" field unless the Module field is populated,, then it needs to be Module instead.

Is "create calculated column" in the report tool an extended or admin function?  We have a few admins in SNOW, the rest are users and don't have access to any advanced reporting utilities.  We would need to create a ticket to request what we want.

I checked your link and it looks like it was redirected to an ITIL page.  I'm trying to find the documentation on how to create a calculated column in SNOW online help but not having any luck finding this in the Reporting tool.  It seems I need to add the calculated column to the physical Incident table first?

Any help would be greatly appreciated! 

Sana18
Kilo Contributor

Thanks for your response, Sachin.

Is there any other way to create dynamic columns without actually creating them in the table while writing a report?

 

Thanks again,

Sana

You can't create columns only in report like reporting tools.

 

 

Regards,

Sachin