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

    LOD calculation questions!

    tian.yang.4

      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)

       

       

      P.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.

       

      P.2

       

       

      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.

       

       

      thanks!