Postgres Bargauge not working

  • What Grafana version and what operating system are you using?
    I am using Grafana 8.3.0
  • What are you trying to achieve?
    I am trying to show multiple values in a bar-gauge.
  • How are you trying to achieve it?
    I used this query:
    SELECT
    NOW() AS time,
    (ROW_NUMBER() over(order by value desc)) || '. ’ || name as metric,
    value
    FROM table
    ORDER by value desc
    LIMIT 10
  • What happened?
    They are ordered by metric name. Starts with 1. {name}, 10. {name} then goes from 2-9
  • What did you expect to happen?
    The result to be ordered by value and not by the name. It worked like this before the update from Grafana 7 to 8.
    Also if I put ${__series.name} in the Display name field it just shows Series (A) instead of 1. {name} for example