Format time series X-axis tick values

Grafana Time Series Panel
1

Hi!
I’m using the Grafana 10.4.2 version with Time Series panel.
I try to format x-axis label. The input is time stamp in a form: YYYY-MM-DD HH:MM:SS (2024-07-31 16:15:59). Spesifally I want to get time value hidden (see attached image). Currently the grouped by day values are misleading because they show 00:00 time information.
Overrides->Field with name → Timethen Standard options > Unit (time: DD-MM)
but it seems to be applied only to the tooltip or hover message, not the x-axis and x-tick values.
I also tried Transform data → Convert filed type - Field Time as Time Input format YYYY-MM-DD , but it did not change anything
Any suggestions?
Thank you in advance!

Screenshot from 2024-08-07 16-28-57
Screenshot from 2024-08-07 16-28-57889×523 17.3 KB

2

Is it possible to use bar chart instead of time series in your case?

For bar chart overriding Unit to time: DD-MM would give the desired result. See this example

3

Well, it does not solve the issue; it is a workaround, thank you, but it has issues. I will explain why:

  • Time Series panel allows for “zoom in” to data - BarChart does not (TimePicker needs to be used)
  • Bar chart allows using of only one numerical type to describe data in the plot if I use decimals (2) in legend for mean and std values, the same type will also be used in Y-axis labels, leading to confusing scales like 1.5 (on plots where whole numbers are counted), or I choose no decimals - then the Y tick labels are correct (natural numbers), but values in legends are rounded to integer numbers (std, mean is rounded to 0 decimal places)
  • Bar chart has bugs - see picture - double numbering on Y axis or changing colours when one category is picked
    In any case, the resulting plot would be of poor quality.

Screenshot from 2024-08-15 11-59-07
Screenshot from 2024-08-15 11-59-07937×358 9.98 KB

4

Time Series and Bar Chart are different panels with different features, and not quite interchangeable. For some tasks bar chart suits well, for others not.

As of now this issue is not resolved, see also relevant discussion here.

1 Like
5

Thank you. The discussion confirms my observation. I’m looking forward to future fixes/versions. So far, I was using “old good Graph,” but unfortunately, now it displays information about the Angular plugin being soon deprecated.