Hello community,
I’m working on a trend analysis using a time series visualization, and I want the X-axis to display dates and the Y-axis to show percentages. However, the time series chart is not recognizing the date column from my data source and is defaulting to some other time dimension. How can I configure it to use the date column from my data source table instead?
You mean timestamps are shown incorrectly? I.e. it should not be 2024-08-18 05:30:00, but rather something else?
What is your datasource and how does time look there?
Yes, ideally the date I want is 2024-12-08,2024-08-13 so on in my x-axis.
Postgresql is data source, and it has date column of format 2024-08-13 etc.
2024-12-08 is considered as 2024-12-08 00:00:00 by Grafana. Grafana considers that data in the DB are saved in the UTC timezone, but it “moves” that UTC data timestamp to your browser timezone (5:30 looks like IST).
Configure dashboard timezone to UTC, so Grafana will keep 00:00:00 in this particular case then.
Thanks for your suggestion, But I’m looking for the dates to be shown in the x- axis which is present in DataSource table. I want to see the trend for each day date and not timestamp.Can you suggest me on how to achieve it
Don’t use timeseries panel, but more suitable panel e.g.xy - query data in desired format and then visualise them.