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!!!
