Duplicated Data - Reports Table

Ignition
1

Hi Guys,

Have an Issue with the reporting feature on Ignition 8.

I am trying to display data in a 24 hour time from starting from midnight to 23:00PM.
image
This column is reading in a Text Value of @t_stamp@,

I have the Rows sorted by TopN, showing 24 rows for my 24 hour datatable. My datatable is pulling in duplicated records and I cannot find where the issue is, would someone be able to steer me in the right direction? Not all times are duplicated as shown below;
image

2

If you run the same query in your database’s management console, are the rows duplicated there too?

3

Ran the query and there was no duplication in the records, ran it in a table via vision.