Allow re-ordering of columns in table panel configuration

[volter]

There currently is no way (other than editing the JSON) to re-order existing fields in a table panel. This is pretty painful, if you have a lot of columns, in particular, if there is no auto-completion.

[jayannah]

+1

[MrBoggi]

I agree. It would be nice to be able to reorganize the columns.
Now I'm stuck with but would like

[marianob85]

+1

[jameswongyou]

+1

[boeboe]

+1

[annevanleyden]

+1

[AInoob]

+1

[amgorb]

indeed +1

[JinlinSong]

+1

[paol]

With Prometheus data sources there is no way that I can tell to reorder columns, not even editing the JSON.
The column order appears to be effectively random. This can make tables really awkward to read.

[torkelo]

Strange , means Prometheus returns them in random order (I think)

[paol]

@torkelo Well, prometheus labels are being turned into columns and labels have no inherent ordering, so that's to be expected.

[cxxly]

+1

[cxxly]

is there any progress?

[Stono]

+1billion to this, a prometheus data source results in columns being displayed in a non-deterministic order which is bloody well rubbish! :)

It'd be great if grafana could control this

[Rellek72]

+1 This is especially painful when trying to use Prometheus, as previous commentators mentioned.

[iamash]

Is there any progress??? This is a MUST have feature, right now you have no control over the table which is ridiculous.
And for Prometheus, I think the order is alphabetically depending on the label name (Giving another column name in Granada won't do anything)

[jeremyxu2010]

+1

[jeremyxu2010]

+1
For Prometheus, the order is alphabetically depending on the label name.
So i get a solution, but it's ugly...
Use label_replace in promQL, rename label to _xx_old_label, something like that:

label_replace(some_metric, "_01_old_label", "$1", "old_label", "(.*)")

[curiTTV]

+1

[s7v7nislands]

+1

[Meta4X]

+1

[yanivroz]

+1

[ksemaev]

+1

[sjentzsch]

sry but here is another +1 ...

[cactusgame]

I think this feature is very useful. +1

[cyyeong]

this is a needed feature!! +1

[TylerZale]

+1

[onedr0p]

:shakes_fist:

[ghost]

yes for influxdb when dealing with tags, the order of columns is imposed by the alpha-numeric order.
please do it 🙏🏻

[debmalyapan53]

+1

[jutley]

For people using Prometheus, I have the world's ugliest hack to get around this.

Suppose I have a query $QUERY that returns vectors with labels $A_LABEL, $SOME_LABEL, and $THIS_LABEL. In my table, I will see the columns in this same order, since I listed them alphabetically. However, I want the order to be $SOME_LABEL, $A_LABEL, $THIS_LABEL.

We can use Prometheus's label_replace to rename my labels so that they are done alphabetically. Then, we can use a sum_by to remove the original labels. This looks like this:

sum by (_0_some_label, _1_a_label, _2_this_label) (
  label_replace(
  label_replace(
  label_replace(

    # The actual query
    $QUERY

  , "_0_some_label", "$1", "some_label", "(.*)")
  , "_1_a_label",    "$1", "a_label",    "(.*)")
  , "_2_this_label", "$1", "this_label", "(.*)")
)

Pretty dumb, right? But it works. Unfortunately, these are ugly names to read, so let's reformat them. Add a column style that matches the regular expression /_\d+_(.*)/. Then set the column header to $1. This way, we strip off our ugly hack and get our original labels as our column headers.

The fact that this is necessary is ridiculous. Column ordering should really be a built in feature. So, you know, +1.

[c6h3un]

+1

[ghost]

To solve this issue, i ussed a custom backend using the json data source plugin https://grafana.com/plugins/simpod-json-datasource.

[WilliamLHarms]

+1

[amytleonard]

I would like this as well

[apanagar]

This would be a great feature

[qyvlik]

+1

[WilliamLHarms]

FYI - the work around to this bug is to edit the panel json directly. Look for the columns block then move the column definition around in the json. (panel dropdown --> more --> Panel Json)

"columns": [
    {
      "text": "level",
      "value": "level"
    },
    {
      "text": "message.text",
      "value": "message.text"
    },
    {
      "text": "@timestamp",
      "value": "@timestamp"
    }

[paol]

@WilliamLHarms That only works for some data sources. Prometheus for example builds the columns dynamically, there is no JSON to edit.

[WilliamLHarms]

@paol - yea, it was an elastic datasource. I guess there isn't a work around for the bug. Just scrap your panel and start over.

[bzon]

We are all waiting for the hero who will apply this feature.

[binduv124]

This would be a great feature to have.

[zimmertr]

Would love to be able to do this as well.

[joker234]

I'd like to see that feature realised.

[ZeroMagic]

The feature will improve the user experience greatly.

[r2dedios]

@WilliamLHarms That only works for some data sources. Prometheus for example builds the columns dynamically, there is no JSON to edit.

Prometheus sort the labels attributes by alphabetic order. Not randomly.

If you have the labels: "hostname", "ip", "cluster", the order will be:

{cluster="", hostname="", ip=""}

But if one label name begins by capital letter the order change.

{IP="", cluster="", hostname=""}

If you want to sort the labels, you can use the label_replace function.

Prometheus Label Replace

[AIXruth]

+1 and btw if the amount of columns is to high, the header row is stuck and not able to scroll with the rest (#4157)

[neeles83]

+1 Why not order on the Column styles order and make them, easy to move so you can drag them on the screen.

[kushalsen38]

@torkelo I still see this is not yet fixed. Using the grafana version 6.7.2.
There should be some ordering option to re arrange the columns.

[torkelo]

Coming in 7.0 via the new transform tab!

[jothibasu-kamaraj]

sum by (_0_some_label, _1_a_label, _2_this_label) (
label_replace(
label_replace(
label_replace(

# The actual query
$QUERY

, "_0_some_label", "$1", "some_label", "(.)")
, "_1_a_label", "$1", "a_label", "(.)")
, "_2_this_label", "$1", "this_label", "(.*)")
)

it worked for me with 20 columns thank you