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:
On my dashboard I have a time series panel, its hsows following x-axis:
@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:
@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?
i posted that thread as it looks like it might come down to you logging a feature request
what is your data source
let grafana do what it does best: visualization
let your data source do what it does best: data manipulation
@yosiasz, thanks fpr your support.
My database is a mysql database.
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
I am trying to achieve the same thing, getting only the month displayed on the x-axis of a Time series panel.
The reason I want to do this is that I am having time series plot comparing values for different years. I am having the data stored in a postgresql database and I am doing some SQL to move all older data to the same day of year in the current year and having the original year as a parameter. (And before somebody tells me about leap years. I am perfectly aware of that, using day of year rather than date, each fourth year gets doy 366, that is not a problem in what I want to do)
For example, a plot of daily production from a solar panel for the years 2021-2025:
It is readable, but would be better if it was labeled with just the month and not the year as well.
By all means, if I have overlooked something and there is another way of getting a similiar plot with “folding” all the years into the current, I could use that. I could of course query postgres to get the columns year, day of year, value and plot day of year vs value in a XY diagram, but then the X-axis label would be day of year (i.e. 1-365/366) which would be pretty difficult to interpret.
You can use Business Charts (echarts) …There you have complete freedom.
here a code example…
axisLabel: {
formatter: function (value) {
const date = new Date(value);
const year = date.getYear()-100;
const monthNames = [“Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”];
const month = monthNames[date.getMonth()];
return${year}-${month};
}
}
