Monthly bar graph

Grafana Bar Chart Panel
,
1

i am using grafana v 9.1.6

I have monthly bar graph something like this :

image
image1368×681 99.4 KB

can you help me to change the value in the red circle into month-year format? like Dec-22
here’s my query

SELECT
  MONTH(DATEADD(SECOND, time, '1970-01-01')) as time,
  STDEV (E_CC14) AS CC14
FROM
  Energy_CC
WHERE $__unixEpochFilter(time)
GROUP BY MONTH(DATEADD(SECOND, time, '1970-01-01'))
ORDER BY 1
1 Like
2

This is not really a grafana question, but more of a sql question

I would ask it in the following forum

3

okay, sorry about that

because in my table, the value of month already changed to 12, but in grafana just showing the hour

image
image512×766 47.4 KB

thanks

1 Like
4

That is because you have selected Format As Time Series

5

@andreapraja11 Have you explored using a custom unit override, for example, like this?

image
image933×244 11.4 KB

1 Like
6

I see you found an answer here

7

yes, thanks for recomend the forum

1 Like