here is a problem that confused me for couple of days.
Here is the mock up data.
Here I want to get the IP MAX in May, and IP is in descending order.
Value of IP MAX is bigger than IP ( Picture 1)
And I find the reason ( Picture 2) is LOD find max IP in each device which is not from a single day.
The red one is from 1st May, and green one is from other date.
So what I want is to get the right MAX IP of May, and get the right max IP in each devices in the same day.
I am not sure what you mean in your 2nd screenshot, can you explain it a bit more?