Hello,
I am getting an error when i run a query. I want to visualize data from a historical tag in a Boxplot.
I bind the query to the boxplot and i use a daterange for date selection. I dont see what its wrong in the query.
Where tagid = '22' and t_stamp between
(DATEDIFF(s, '1970-01-01 00:00:00', {Root Container.Date Range.startDate} ) as bigint) * 1000) and (DATEDIFF(s, '1970-01-01 00:00:00', '{Root Container.Date Range.endDate}' ) as bigint) * 1000) ```