4 Replies Latest reply: Dec 21, 2016 2:03 AM by murli mohan RSS

    Set analysis with criteria that includes timestamp

    ben lim

      Hi everyone, I have a question. I cant do it on dimension so is purely on set analysis expressions.

       

      sum({<Day(Date1)=(Day(Date2))}>} Revenue)

       

      Basically i want to sum the revenue if the DAY for Date 1 and Date 2 are on the same DAY.

       

      i.e

      Customer booked a hotel room on nov 11 (Date1) and checking in on the date itelf (nov 11), i would want to count these on the same date check in itself on the revenue.

       

      I cant do in script nor dimension.

       

      How should i do