I’m trying to graph the count of different entries in the “Homebase_Name” column. It bar graphs correctly if I use NOW() AS “time”, however I can’t limit the date/time range of course. I tried specifying the column ‘Date’ AS “time” but Grafana returns an error “invalid type for column time, must b…

Thanks for the headsup on that! I finally got it working to Bar Graph within a selected range using these queries below. SELECT Date_Time AS “time”, Homebase_Name,COUNT(Homebase_Name) FROM Homebase View WHERE Homebase_Name = ‘Off-Base’ AND $__timeFilter(Date_Time) GROUP BY time SELECT Date_…

Invalid Type for Column Time MySQL

Grafana

wlargou February 24, 2021, 7:36pm 2

Hi,

Please check this post if relevent :

Hope it helps.

Good Luck

Topic		Replies	Views
Mysql Query BUG Grafana Plugin Development mysql	5	1028	April 9, 2018
MySQL Invalid type for column time/time_sec, must be of type timestamp or unix timestamp, got: <nil> <nil> Grafana	0	2928	December 13, 2018
Errors using TIMESPAN from SQL server when implementing a single stat diagram MySQL mysql	0	324	August 9, 2019
Error Invalid type for column time, must be of type timestamp or unix timestamp, got: string postgres	1	2709	February 24, 2021
MYSQL Query - driver.Value type time.Time into type *sql.RawBytes Grafana	4	2241	July 11, 2018

Invalid Type for Column Time MySQL

Related topics