Grafana bar gauge multiple queries order by value

Grafana Dashboards
1

Hi,
i have a bar gauge dashboar that has multiple queries and i want to order them by value

image
image1452×389 13.7 KB

It has multiple queries such as this:

image
image1436×640 49.7 KB

All the data comes from influx.
I tried with the sort by transformation but it doesnt make sense for my case:

image
image1332×507 19.3 KB

2

Quite a dirty solution involving several transformations, but could work for your case:

sort
sort1918×1021 106 KB

3

when i apply the first transformation i got just one query, i dont know why

image
image1455×902 39.3 KB

4

Can you join those 2 queries using Join by field first then apply sort?

5

how do i do that? I have 8 queries

6

do they have a shared/common field you can use?

image

7

Maybe i have an older version cause i dont have that transformation :frowning:

8

Is there another way?

9

If it’s possible to redesign InfluxDB side, I would go that way. I.e. to store everything in one bucket, using different tags. And have only one query to get all measurements.

1 Like
10

exactly! @coricajuan5 your design approach is exposing you to this challenge.

  1. upgrade
  2. if not able to upgrade, each maquina should not be a separate bucket.