Derived colum

[DicksonT]

I have slightly different requirement. When adding incident table as a data source. I want to create a derived column. This column will hold a substring of one of the existing columns. Ex: I want to get a substring of the existing column-short description into this new derived column and use the derived column for group by in my graph. Is this possible?

[olgaredkina]

Hi @DicksonT ,

I think what you refer to are function fields. You cannot add it directly in the UI of data source selection in data visualisation, but you can add function field to a table either from "Reports" UI or from table administration UI.

Here is the link to documentation for more details: https://docs.servicenow.com/bundle/xanadu-platform-administration/page/build/platform-functions/conc....

Regards,

Olga