Binding Power Table to Tag History is logging at irregular intervals

I want to use a Power Table to record flow totals daily and accurately. Currently, I have set the aggregation mode as follows:

What is happening is that actual polling time is drifting, and occasionally days are missed completely. I am using Edge and do not have access to Database scripting at the edge. However this is serving as a tag provider to another Ignition gateway which does have database scripting.

The PLC is running my totalizers and updating tags at midnight. I want to grab these tags and display yesterday’s totals.

Here are my timestamps for the above configuration. Notice that the interval is never actually 24hrs, and that 4/16/2025 was missed completely

Even for testing with smaller intervals, like 1 minute (see below), the timestamp is drifting.

Has anyone encountered this, or have a solution to this matter? If database scripting is recommended, then is this not the intended purpose of using the PowerTable to display tag history?