Set analysis with criteria that includes timestamp

[n1ef5ng1]

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

[sushil353]

hi,

you can use if(Date1=Date2,sum(Revenue),null())

[shraddha_g]

try

sum(if(day(Date1) = day(Date2),Revenue)

[avinashelite]

simple could be to add a flag in the script so that your set analysis becomes simple and improve the performance

if(Date1=Date2,1,0) as Flag

sum({<Flag={1}>}Revenue)

[Anonymous]

Hi Ben,

Find the attached QVW file, it may help you.

R/Murali