Count if using Set Analysis

[anushree1]

HI,

I am trying to get the count of orders where estimated delivery date=ship date (Ontime deleveries) and estimated delivery date>=shipdate+5(offbeat deleveries.)

I have achieved it through count if like :count(if([Ship Date]=EstimatedDeliveryDate,[Order ID]))

But can this be written using set analysis i did try count({<[Ship Date]=p(EstimatedDeliveryDate)>}[Order ID]), but does not work

Also how can i find offbeat deliveries i.e., the second case using set analysis

I do understand i can create a flag in the script and pass it as condition in set analysis.

But would like to know if it can be done without creating any flags in the backend

[sunny_talwar · Accepted solution]

May be try this

Count({<[Order ID] = {"=[Ship Date] = EstimatedDeliveryDate"}>} [Order ID])

[anushree1]

sure it does thanks, how about the second scenario if shipdate>estimatedeliverydate+5

[sunny_talwar]

May be this

Count({<[Order ID] = {"=[Ship Date] > EstimatedDeliveryDate + 5"}>} [Order ID])