I am using the power chart, and am experiencing problems with points that are not connected by a line. In the first picture, it seems like the chart forgot to interpolate between two points. Seems like it is mostly happening in periods where the value was constant.
However, when i try to plot a third tag, the problem disappears. Why? What can i do to make this work reliably?
There was no error on the tag value in the period. I want all the lines to be connected (but bad quality values can still be missing).
By the way, my historian stores a data point once every hour if the value does not change.
I used this query to get the historian data for the tag:
SELECT DATEADD(s,t_stamp/1000,'1970-01-01 00:00:00') as timestamp, floatvalue,dataintegrity, querymode, datevalue,intvalue,t_stamp,tagpath FROM sqlt_data_1_2025_03
inner join sqlth_te on sqlth_te.id = sqlt_data_1_2025_03.tagid
where sqlth_te.tagpath LIKE '%myTagPath%' AND t_stamp < 1742987521105
order by t_stamp DESC
The data look normal to me, so i dont understand why there are gaps:
This is a typical query i use for inspecting raw historical data in the database:
SELECT DATEADD(s,t_stamp/1000,'1970-01-01 00:00:00') as timestamp, floatvalue,dataintegrity, querymode, datevalue,intvalue,t_stamp,tagpath
FROM sqlt_data_1_2025_07
inner join sqlth_te on sqlth_te.id = sqlt_data_1_2025_07.tagid
where sqlth_te.tagpath LIKE '%cell5/temperature1/value%'
AND DATEADD(s, t_stamp/1000, '1970-01-01 00:00:00') > '2025-07-07 00:00:00'
order by t_stamp ASC
