1 Reply Latest reply on Nov 8, 2018 7:48 PM by Zhouyi Zhang

    LOD calculation questions!


      hello experts,



      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.