I'm working on migrating data in our database from a transaction group table to a historian table. The historian table already has data for roughly the 2nd half of the month in this example (starting November 11, 2025), while I am importing the transaction group data for the first half.
I am able to query the tag history in Ignition and see all of the data for the month, as well as see it all in a power chart. However, when I zoom into the imported data, or scroll away from the already existing historian data, the data disappears. I've tried changing the 'aggregateMode' property on the chart data, which fixes the issue for some options, but it also distorts the data in undesired ways.
Here is a snippet of the historian table where I imported the data into. I scrolled to the point in time where the imported data meets the already existing data for comparison. As far as I can tell, the only difference between the two is that the imported data has rounded values, and the time stamp is given in exact 30 seconds intervals.
Is there anything I am missing in this migration that would be causing the power charts to be acting this way? Since it can see the data as a whole, my guess was that there's an aggregation issue.