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.

[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.