Grafana version: grafana-v10.3.1

I have 3d data (2 coords + z value) and want to be sure each axis is in the correct order (numeric ascending). The query can only give the right order to one coordinate. e.g. ORDER BY x, y produces the following:

x | y |
---|---|

0 | 1 |

0 | 2 |

0 | 5 |

1 | 4 |

1 | 5 |

The y axis would then have an order like 1, 2, 5, 4…

I first am using a “Grouping to Matrix” transformation to help with formatting the data. So I would get something like this:

x/y | 1 | 2 | 5 | 4 … |
---|---|---|---|---|

0 | z’s… | |||

1 | … | |||

2 | ||||

… |

Then I apply an “Organize fields by name” to order the columns appropriately (note the 4 and the 5 switch):

x/y | 1 | 2 | 4 | 5 … |
---|---|---|---|---|

0 | z’s… | |||

1 | … | |||

2 | ||||

… |

This works great! The transformation already has the fields ordered numerically when it spawns. I just drag the “x/y” field to the very front. However, when I then go to the dashboard and change a variable, the ranges of values change and the “Organize fields by name” transformation simply takes the order returned by the query, rather than doing what it would have done, had I simply applied it by hand again…

How can I make this work on it’s own i.e. dynamically? Can this work? It seems like an expected functionality, to be able to order columns/rows by their numeric value at run time. Thanks!

PS - I am using Apache ECharts plugin which does not have the option to apply overrides.