1 Reply Latest reply: Jun 11, 2018 10:38 PM by Sunny Talwar RSS

    set a dimension with Max and min values

    Gaurav Atluri

      Hello,

       

      Have a question,

      how to work this situation.

       

      I have a table with the below fields:

       

      Dimension1,

      Date,  MM/DD/YYYY HH:MM:SS

      Landmark, 'A'-'Z'

      Start Timestamp,MM/DD/YYYY HH:MM:SS

      End Timestamp.MM/DD/YYYY HH:MM:SS

       

      I have to distribute DImension 1 into Day and Night

       

      if ( ( Date greater than min({<Landmark = 'D'>}Start Timestamp)

      and

      ( Date less than max({<Landmark = 'Y'>} End Timestamp) ),

      'Day','Night').

       

      How can this be achieved.

       

      Thanks,

      Garry