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.



      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