Macro $__timeGroup does not work - ERROR: query error: pq: unbalanced (

Grafana PostgreSQL
, , ,
1

  • What Grafana version and what operating system are you using?
    8.3.3

  • What are you trying to achieve?
    Group my rows by date (day)

  • How are you trying to achieve it?
    Using $__timeGroup(timestamp, ‘1d’),

  • What happened?
    For a simple “test query” i get the error ---- db query error: pq: unbalanced (

  • What did you expect to happen?
    get columns grouped by time

image
image631×542 36.4 KB

I dont get it why it doesn’t work. I practically used the query suggested in the help and it still does not work. I need this to make work my BAR CHART panel.

image

Can pls someone help me with this. I tried everything and i cant seem to find the solution for this.