Monthly bar graph

i am using grafana v 9.1.6

I have monthly bar graph something like this :

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

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

I would ask it in the following forum

okay, sorry about that

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

thanks

1 Like

That is because you have selected Format As Time Series

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

1 Like

I see you found an answer here

yes, thanks for recomend the forum

1 Like