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

**URL:** <https://forum.inductiveautomation.com/t/why-is-my-historical-report-fixed-data-source-repeating-rows-twice-the-sample-size-i-set/66039>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 3, 2022, 3:21am UTC](https://forum.inductiveautomation.com/t/why-is-my-historical-report-fixed-data-source-repeating-rows-twice-the-sample-size-i-set/66039 "2022-11-03T03:21:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wakatipu](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wakatipu/32/70339_2.png) [@wakatipu](https://forum.inductiveautomation.com/u/wakatipu)\
**Post date:** [November 3, 2022, 3:21am UTC](https://forum.inductiveautomation.com/t/why-is-my-historical-report-fixed-data-source-repeating-rows-twice-the-sample-size-i-set/66039/1 "2022-11-03T03:21:50Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/e/9e54a435ba46aac6ed23ebba3ddb16dd56ae1df6.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 3, 2022, 11:23am UTC](https://forum.inductiveautomation.com/t/why-is-my-historical-report-fixed-data-source-repeating-rows-twice-the-sample-size-i-set/66039/2 "2022-11-03T11:23:04Z")

</div>

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

Choose a different aggregation mode.

---

<div class="post-metadata">

**Author:** ![wakatipu](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wakatipu/32/70339_2.png) [@wakatipu](https://forum.inductiveautomation.com/u/wakatipu)\
**Post date:** [November 3, 2022, 9:18pm UTC](https://forum.inductiveautomation.com/t/why-is-my-historical-report-fixed-data-source-repeating-rows-twice-the-sample-size-i-set/66039/3 "2022-11-03T21:18:00Z")

</div>

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