Rounding up a decimal and filtering to create discrete values

[Skemaz]

Hi

I have a table with a large number of rows from data recorded at very close time intervals.

In the screen-shot below, I have a number that I'd like to round up a few decimal points and then flter to remove duplicates based on two of the columns combined (Horse Name & UTC Time).

Horse Name is in the 1st column in the screen-shot below.

The example of the "UTC Time" shown below is (1) 42862.50367 in the table and (2) 42862.5036666667 when I inspect it. 

What I'd like to do is round up the above example to 42862.504.

In doing so, I'll wind up with duplicates (of Horse Name & UTC Time), so I'd then like to filter the combination so I wind up with records that are unique by Horse Name & rounded UTC Time.

I'm sure there's a way to do this but I can't seem to figure it out.

I'll appreciate any assistance.

Thanks, Mark.

[MFelix · Accepted solution]

Hi @Skemaz,

In the querry editor add a custom column with:

Number.Round([UTCTime],2)

Then use that column to remove your duplicates.

Regards,

MFelix

[Skemaz]

Hi MFelix

Many thanks for helping.

Best regards, Mark.