What Grafana version and what operating system are you using? Windows What are you trying to achieve? Plot cnadlestick time series data How are you trying to achieve it? Through clickhouse query What happened? Getting “Data missing time field” error What did you expect to happen? …

I took out toUnixTimestamp function and don’t see that error anymore. thank you

[image] svctradingbqm: toUnixTimestamp(TimeBarStart) as time welcome @svctradingbqm Why are you doing the following toUnixTimestamp(TimeBarStart) as time What data type is TimeBarStart

what does it look like if you dont use that function but rather use convert field transformation and convert it to time

Hello, Not quite sure what you mean. Without that function, raw data looks like below. Is the error due to time format issues or time column not being there? I do see ‘time’ column time 2020-01-02 09:00:00 2020-01-02 09:01:00 2020-01-02 09:02:00 2020-01-02 09:03:00 2020-01-02 09:04:00 2020-0…

[image] svctradingbqm: time format issues time format. the datatype might be string date and grafana some versions have issues with that. so you can use transformation to convert to time

I’ve a different issue now. I am using candlestick to display this data. Numbers are float, however tool tip shows integers. Any idea how to fix? Thank you

same thing, use convert to convert to number maybe?

Data missing time field

Grafana Dashboards

svctradingbqm June 6, 2024, 9:54pm 3

It’s datetime64 type in clickhouse database. Looks like below in table view

Topic		Replies	Views
MSSQL : Error 'Data is missing a time field' Dashboards timestamp	3	5884	June 28, 2023
Time series from CSV data Dashboards csv , dashboard	4	8684	December 9, 2022
Why does Grafana change my data Grafana	3	1077	June 22, 2022
InfluxDB source: Data is missing a time field InfluxDB	5	259	August 7, 2025
"Data does not have a time field"; what do I have to do to get Grafana recognize 'time' attribute? Time Series Panel	9	59791	June 23, 2021

Data missing time field

Related topics