Report grouping based on substring of short description (letter cases sensitive issue)

[Joe Wong]

Hi ServiceNow Community,

Running into a roadblock and seeing if there is anyway around this.  I am creating a report on Platform Analytics where it needs to group by the first 13 characters from the short description field.  The most straight forward way and one which I got closest to the solution was using a Function Field and glidefunction:substring.  This works until I noticed that some of the short descriptions letter cases are different.  Example is I have one that is "Equip Setup" vs "Equip setup" is group is separate groups because of the upper and lower case "S" in the word "setup".

There is no glidefunction to lower all cases and I have also tried Calculated Field, but that does not work with reports.

Any thoughts on this, or am I doomed to need to export this data and run the report on Excel...

Thanks!!!

[Tanushree Maiti]

Hi @Joe Wong ,

Check https://www.youtube.com/watch?v=6bzzJNm7YHk

Function Fields in ServiceNow Reports: Calculate and Display Data on the Fly

https://www.servicenow.com/community/platform-analytics-forum/report-configure-function-field-help-r...