Hi Please see below image
Query i have created
Im trying to show just unique values by Unit_ID. i tried the options under properties "Show unique values", "Show unique records" but its not working since date is difference.
As per above image i just need to show Unit_ID's 55555 & 55556 once. How to do this part?