Sorting the order in Grafana Dashboard

We have created a dashboard using stats chart type and taking the last value in the timeseries.
In this we have the time series data for each of the nodes that we are monitoring. and we are taking last observed value to be shown on the dashboard.
We want the data to be sorted by the names of the node but can’t find option to do it. If I select sort by transformation then it shows me name of each of the node indivdially but don’t give me the option where I can sort all the result based on the name

This is what I get when I try to use SortBy transformation

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?