Custom ordering of Stages in a report

[Nathalie Cancik]

I have a bar report grouped by Stage. My requirement is for these Stages to be presented in the same order that the stages are in for a specific catalog item process. I haven't found any information about custom ordering for Stages within ServiceNow Reporting capabilities. All I've seen is to sort alphabetically a-z or z-a. Does anyone know how/if it is possible to custom order the stages in a report? Or can provide any workaround solutions? 

[AnubhavRitolia]

Hi Nathalie,

Can you share the report Screenshot and what is your exact expectation and which table you are running report on.

[Saurav11]

Hello,

Please follow the below step to create custom order for any field. Go to report ranges from navigation:-

then over there create new record from the table and field and give the order. so for example foe field state I want the order to be work in progress, open and close complete

So here you give the label the table name the field you want to cutomize and the order and also the value for which you are customizing

Similarly create it for all the values of that field you want to custom sort

Then on the report too it will appear in the same order as you have defined.

Please mark answer correct/helpful based on Impact.

[Callum Spiers]

This is exactly what I was looking for - although as an FYI report ranges apply to all reports on that table.

It seems that the sneaky workaround is to create a database view on the table you're after i.e. if trying to group incidents by state, but also ordered by state like new >then> work in progress >then> resolved you create a database view where incident is joined to itself, and call it like incident_state_report_group and add the report range to that (so new's order=100, work in progress order=200 etc).