XY chart: X axis label

Grafana Dashboards
1

Grafana newbie here.
I am using Grafana v9.3.6. I need to Scatter_plot data over a time period, and i used XY charts.Is there a way to display the Date( YYYY-MM-DD format )
in the x-axis of the XY chart. when in date format, the displayed date is a
7 digit number(timestamp). And the override doesn’t seem to work in the axis label.
Override works on the tooltip, but in the x-axis label, it is still the 7-digit number.
Thanks in advance.

2

Hey. Do you have a solution for your problem?

3

welcome @gapsong

What is your data source?

4

I am using Postgres as my datasource

5

use something like this in the query (we cant see your query but this still should work)

SELECT TO_CHAR(YOUR_DATE_COLUMN::date, 'dd/mm/yyyy');
6

I have the same problem where my X axis is date and Y axis is percentage, tho on tool tip date is shown correctly and graph looks okay. X axis ticks are shown as numerical representation of the date field and not actually date. If i try the solution you mentioned since the field is now string, not able to use it as a X field and graph is empty

My date source is SQL
I tried using transformations to convert field to string as well, that didn’t work either

My assumption is XY chart expects numerical field on X axis and hence converting date to numerical , so tick display is same but fixes it on tooltip

How to fix the tick label here?

7

@yosiasz could you help please?

8

we cant see your database remotely so you will need to be a bit more specific

please provide DDL and DML