Create a table showing value hour by hour in Reporting module

Hi, I’m trying to create a table showing the last 24 values polled every hour from several historic tags. However, in the designer the data source only seems to hold onto one value making it impossible to create a table with. I might be wildly misunderstanding how the tag historian query works.

I saw some threads talk about the “LastValue” Aggregation mode but i’m on 8.3 and don’t have that option.

Any suggestions appreciated!

Set your interval to 24 Hour.

Make sure your start date has zero minutes, seconds, and milliseconds. Make sure your end date is 24 hours after the start date, less one millisecond.

1 Like

Hi, thanks for your comment.
Somehow I still get only one value not a set of 24.

Based on this Tag History Bindings in Vision | Ignition User Manual it seems to me that Interval should indeed be set to 1 hour.

7.8 is mega old. Many many changes since 7.8 and 8.3. Go for the 8.3 documentation and work off that.

Thanks, i updated the reference to the 8.3 manual which says the same thing.

I ended up using scripting for the data source. There’s something off with the tag historian query.