How can I sort the X-Axis

Gabriele7
Tera Contributor

‎02-02-2022 06:23 AM

Hi, 

I hope all are well. 

Today I have a questions to the sort the x Axis. I use the Type: Bars (first choice). The x-Axis are the priority and the y-Axis is the Average of Business elapsed time (table task_sla).

At the moment the x-axis is not sorted by prioriy 1 to 5 . It is sorted by the highest to the lowest y-value as you can see in the attachment. 

How can I change the sort of the x-axis?

Thank you for your help

Labels:
Preview file
35 KB
0 Helpfuls
  • 2,011 Views
7 REPLIES 7

Voona Rohila
Kilo Patron
Kilo Patron
In response to Gabriele7

‎02-03-2022 02:26 AM

You can show a multilevel pivot which shows priority with a specific sort.

find_real_file.png


Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP
Preview file
16 KB
0 Helpfuls

Jaspal Singh
Mega Patron
Mega Patron

‎02-03-2022 02:45 AM

Hi Gabriele,

 

What table report is on? Is it on Incident SLA? If so, I suggest you to use Sort option.

You will find where you apply all filters for the report.

Jaspal Singh
Mega Patron
Mega Patron
In response to Jaspal Singh

‎02-03-2022 02:46 AM

I see you mentioned its Task SLA. Can you try using any database view table.

OOB Incident SLA table exists & then you can sort by priority A-Z