Override regex not working

  • What Grafana version and what operating system are you using?
    8.4.4 on docker

  • What are you trying to achieve?
    Change the series style to Bar in the timeseries graph for several queries by using a regex-overwrite.

  • How are you trying to achieve it?
    By using regex
    image

  • What happened?
    Nothing, all graphs are still shown as Lines.

  • What did you expect to happen?
    The temperature graphs ‘TempNick’ and ‘TempWZ’ to be displayed as bar-graphs.

  • Can you copy/paste the configuration(s) that you are having problems with?
    These are the queries in place:

SELECT
  ts/1000 AS "time",
  val AS 'WP' 
FROM ts_number
WHERE
  $__unixEpochFilter(ts/1000) AND
  id = 48
ORDER BY ts ASC

SELECT
  ts/1000 AS "time",
  val AS 'TempNick'
FROM ts_number
WHERE
  $__unixEpochFilter(ts/1000) AND
  id = 71
ORDER BY ts ASC

SELECT
  ts/1000 AS "time",
  val AS 'TempWZ'
FROM ts_number
WHERE
  $__unixEpochFilter(ts/1000) AND
  id = 73
ORDER BY ts ASC
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No

  • Did you follow any online instructions? If so, what is the URL?
    Add a field override | Grafana Labs

  • Observations
    When using Override option ‘Fields with name’, the only possible selections are
    image

Thus I’d assume the regex should be able to filter on excatly those, but:

  • When I change the regex to .* all 3 queries are displayed as bar-graphs.
  • When I change the regex to .*W.* all 3 queries are displayed as bar-graphs.
  • When I change the regex to .*WP.* nothing happens.
  • When I change the regex to .*Temp.* nothing happens.
  • When I change the regex to /.*Temp.*/ nothing happens.
  • When I change the regex to /Temp.*/ nothing happens.
  • When I change the regex to Temp.* nothing happens.

When I try the same in play.grafana.org by adding XX to some querie aliases it works with pattern XX.* !

Any ideas what’s going wrong?

Thxs

so this is working on play.grafana but not on the 8.4.4 docker image?

yes, that’s correct. When it was not working in docker 8.4.4 I tried in play.grafana and had no issues there.