Sort Columns without using Organize Fields

Grafana Table Panel
1

  • What Grafana version and what operating system are you using?
    I’m using Grafana 9.2.5.

  • What are you trying to achieve?
    I have created a table using Flux. In this querie i created one column per month and it looks like this:
    image
    My problem is that Grafana is sorting the columns in a weird way.
    In this table i have the column for this month sorted on the left side of the panel. But the other months of 2023 are sorted to the right.

    image
    image1251×78 5.52 KB

    The Query will create a new column for every new month.
    Is it possible to sort the columns without using the transformation “Organize Fields”?
    I dont want to sort the columns manualy every month.

2

Hi @patse, :wave:

Thanks for opening this issue.

Can you please send us this data (the one you shared in the screenshot) as a CSV so that we can test it out and see how it can be solved?

3

Hey @usman.ahmad ,
i will need a few days to get the permission to share the csv.

4

Hey, I have the same problem. I also want to know how to sort the columns.
Did you get permission to share the CSV?