Why is my historical report fixed data source repeating rows, twice the sample size I set?

Hey everyone,

I am trying to configure a historical, fixed data source (tags) in a report to return a total of 24 rows, one for each hour. My EndDate parameter is now, and StartDate is now minus a day. It returns 48 rows, which appears two for each hour, except it is duplicated exactly. For example the last two rows are both assigned the timestamp 2022-11-03 13:15:13.306, with the exact same tag data, but I just need to eliminate these duplicated rows to get exactly what I need to achieve.

Anything in particular I am missing, or a reason why this is happening? Data source config attached in the image.

Thank you in advance for your assistance.

Aggregation mode Min/Max will return one row for minimum and another for maximum values seen in that period.

Choose a different aggregation mode.


Yep that was it! Just changed aggregation mode to Maximum and got exactly what I was after. Thanks for the help Transistor.