Reports - Question choice not sorting correctly

Trupti Krishnam
Tera Contributor

TruptiKrishnam_0-1696421383638.png

I want the X axis choice value to be sorted in the order. as 01 , 02... 15. I have tried creating a user preference.but did not work  @pranavbhagat  , @ctomasi ,  @earliodookie, @poshprogrammer      could you please help!

2 REPLIES 2

Community Alums
Not applicable

Hi @Trupti Krishnam ,

Unfortunately it's not possible as of now.

Please read the KB from ServiceNow as why it's not possible: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0761070

However, you can still try :

You can you "Add sort" option on your of condition section:

SandeepDutta_0-1696427678904.png

 

 

AndersBGS
Tera Patron
Tera Patron

Hi @Trupti Krishnam 

 

In the report designer you have the "add sort" where you can sort by specified field in the range A-Z or Z-A.

 

AndersBGS_1-1696484960388.png

 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/