Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to sort Report Legends as per choice Order ?

Teju Dhoran
Kilo Sage

‎02-26-2023 11:56 PM - edited ‎02-27-2023 05:57 AM

Hi team,

I have report of type Column, Report is grouped by Stage field (choice type), The report shows legends in Alphabetical order. We want legends to be shown as per the Stage order.

Report Ranges is not working on choice field.

 

TejuDhoran_1-1677484520165.png

Here legends are sorted in alphabetical order, but I want it in below order

Open,  Planning, Doing, Close

 

Can some one help?

 

0 Helpfuls
  • 938 Views
5 REPLIES 5

Greg Arvidsson1
Tera Contributor

‎04-02-2023 07:13 PM

Stage is a field of type "Workflow".  I believe that Report Ranges only works on fields which hold only dates, lists or integers - https://docs.servicenow.com/bundle/utah-now-intelligence/page/use/reporting/concept/c_ReportRanges.h...

You could create a custom Choice field, which stores a copy of the Stage field, which gets updated by a Business Rule when the source record changes.

0 Helpfuls