Set analysis syntax

[Anonymous]

Hi All,

How to find greater than in set analysis

example

if(AppointmentDate>Order_date, count(Reason),0)

How to add the above statement in set analysis

Thanks in advance

[Anonymous]

Hi Shanmuga,

Please try:

In UI use below expression in set analysis
Count ({<(AppointmentDate = {"=AppointmentDate > Order_date"} >} Reason)

or

Count(if(AppointmentDate > Order_date,Reason))


or

Create a flag in Script:

if( AppointmentDate >Order_date,1,0) as Dateflag,


and in UI use below expression in set analysis:

count({<Dateflag={1}>} Reason)

Regards

Neetha

[PrashantSangle]

Hi,

Try something like this,

Count({<AppointmentDate={">$(=Order_date)"}>}Reason)

or

count(if(AppointmentDate>Order_date,Reason,0))

Regards,