Replace date values on x-axis by readable values like JAN, FEB, MAR, etc

Grafana Time Series Panel
1

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

  • What are you trying to achieve?
    Replace Date value by month name on time series panel x-axis.

But I want to replace the date values (like 2024-01, 2024-02, 2024-03, etc.) by the values from column 'Monthnameshort like JAN, FEB, MÄR, etc.

How do I do that please?

I have following data:

G2

On my dashboard I have a time series panel, its hsows following x-axis:

G3
G3851×26 5.43 KB

2

try changing the unit, you have to type it in, time:MMMM

image
image826×961 51.9 KB

3

@sowdenraymond: Thanks, but unfortunately this does not work.
On the x-axis I still have 2024-01, 2024-02, 2024-03, etc.
It seems it has only effect on the tooltip:

G4

4
5

@sowdenraymond, Thanks again, but changing the settings in grafana.ini makes this a general rule tha applies to all time series panels.
If I set this to e.g. MMM in every time series panel I get (just) the short monthname.
But may in other time series panels I want to get YYYY-MM, etc.

I wish to have an option to select one column für ‘time’ and another one for the display value.
Or any other hack?

6

i posted that thread as it looks like it might come down to you logging a feature request

7

what is your data source

let grafana do what it does best: visualization
let your data source do what it does best: data manipulation

8

@yosiasz, thanks fpr your support.
My database is a mysql database.

9

so as the name indicates time series requires some form of date and time.

I am not sure what you want can be accomplished with time series but bar chart

image
image1163×639 37.3 KB