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: