Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Count({<[Order ID] = {"=[Ship Date] = EstimatedDeliveryDate"}>} [Order ID])
May be try this
Count({<[Order ID] = {"=[Ship Date] = EstimatedDeliveryDate"}>} [Order ID])
sure it does thanks, how about the second scenario if shipdate>estimatedeliverydate+5
May be this
Count({<[Order ID] = {"=[Ship Date] > EstimatedDeliveryDate + 5"}>} [Order ID])