Reports Error: WARNING: Invalid order by field "null": You can only order by the "Group By" field and/or the "Stacked" field

Thalley Creek
Kilo Contributor

Hello,

If I choose not to sort, the pie chart in the first image below sorts how I would like but displays the error "Error: WARNING: Invalid order by field "null": You can only order by the "Group By" field and/or the "Stacked" field"

As shown in the second image, when I sort by the Group By field "Assigned To" as the error message indicates, the pie sorting is not ordered.

How can I correctly sort the pie chart without displaying an error?

Many thanks
-TC

 

find_real_file.png

find_real_file.png

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

Try switching to the old UI and removing the sort there.  Then save the report and switch back. The error should be gone.

View solution in original post

3 REPLIES 3

Adam Stout
ServiceNow Employee
ServiceNow Employee

Try switching to the old UI and removing the sort there.  Then save the report and switch back. The error should be gone.

I've been working on this pretty much all day and this was the solution.

Thank you so much!!

Thank you.  I would not have found this one.  Why does it only show in the classic UI?  Frustrating!