Different column sorting for individual list data visualisations on different dashboards

[hildec]

I have several list-type data visualizations on different dashboards. For the most part I sort them descending by number (newest first). Occasionally I would like to sort some lists by a different column such a Next Work Ranking. 

However, when I sort one list by Next Work Ranking it will sort every other list of the same type (RITM for instance) on every other dashboard will be sorted by next work ranking. Even if Next Work Ranking isn't a visible field on the list. 

The same goes for any column. 

Is there a way to sort for just a by a column SINGLE list visualisation without having it also be applied to all other lists?

Thanks.

[Jared Hampton1]

This is expected behavior in ServiceNow. List data visualizations on a dashboard share the same sort preference at the user + table + view level. When you sort one list widget, ServiceNow saves that preference for that table and view combination, so all other widgets showing the same table and view reflect the change.

The cleanest fix is to use different views for each list widget:

1. Navigate to the table (e.g. incident.list)
2. Create separate named views for each widget — right click the column header and select View → Save as new view
3. Go back to your dashboard and configure each list widget to use a different view

Since sort preferences are stored per view, each widget will maintain its own independent sort order.

OR if you want a completely independent sort that is not affected by user preferences at all, consider using a report instead of a list widget. Reports have their own hardcoded sort configuration and do not share state with the table's list view.

[Ray Gellenbeck]

Sorry, but I'm going to have to respectfully disagree with "expected behavior."  If they need to adjust, fix or whatever more-pleasant lable you want to put on it, this has to evolve.  If they are going to force people onto PA, then PA needs to be more useful for development in that I should be able to clone 5 visualizations of the same data source and revise them each as needed for whatever reporting slice each calls for without it stepping on each other.

We will agree to disagree at excusing this as a expected behavior.

[Ray Gellenbeck]

Further, as the other respondant states, there is no method for selecting a view in a data visualization, only a table.  I can't share screenshots for illustration as our environment can't be shared but I might with a PDI later on.

[hildec]

Thanks for the quick response. 

When I right click on a column header there is no "View -> Save as new view" option. The only options are Group By Number, Show visualization, Pin to start and Pin to end. Some columns only have Pin as an option.

Reports have been discontinued and replaced by Data Visualizations so that is not an option. 

Thanks.