Change dashboard date format

Grafana Configuration
1

“I have a Grafana dashboard with time series charts, and currently, the date format is set as DD-MM-YYYY HH:mm:ss. I would like to know if it’s possible to change this format, but I’ve already edited the grafana.ini file, which changes the format for the entire Grafana system. Is it possible to change the date format for just this dashboard?”

I know I have multiple formats but how can I set the timeseries to use for example interval_year.

My current query

SELECT STR_TO_DATE(CONCAT(year, '-01-01'), '%Y-%m-%d') AS time, quantity AS value
FROM net4co2.annual_green_house_gas_data
WHERE category = '$category'
ORDER BY time;

image
image963×262 62.4 KB

Current chart time display

image
image909×319 26.4 KB

If I changed the default system format it will be okay, but I don’t want to change all system to that format

2

After editing your grafana.ini, did you restart grafana?

Also what is your data source? mysql, postgres?

Also

3

Yes if I edit the config that I told you I got only the year on display and that’s good. But then all system has date time format with only YYYY.

I’m using MySQL for database.

1 Like
4

Hi @goncalosimoesbastos ,
You can use define custom unit, for example time: DD.MM.YYYY , for Time field in override section:

image
image1919×817 89 KB

 

See next post for more information:

 

Best regards,
ldrascic

2 Likes
6

Thanks, works perfectly for the format time. Great job man