Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following rules:
When a car is loaded with packages it gets a unique shipmentID. When the car is done with the delivery route and is reloaded it gets a new shipmentID.
Every package has a unique packageID. And every packageID has a PromisedDeliveryDate and DeliveredDate.
A shipmentID can have multiple packageID, but a packageID can only be connected to one shipmentID.
I can already successfully calculate how many packageID that are delayed by this:
Count({<packageID={"=PromisedDeliveryDate < DeliveredDate"}>}packageID)
Now I want to calculate how many shipmentID that had atleast one delayed packageID connected to it.
I have tried the following but it doesn't get the right result
Count({<packageID={"=PromisedDeliveryDate < DeliveredDate"}>}DISTINCT shipmentID)
Count({<packageID={"=PromisedDeliveryDate < DeliveredDate"}>}packageID) - if this set analysis can give you the packageID, why don't you use it? I could see from the 2nd set analysis DeliveredEventDate was used instead of DeliveredDate. Might it be the cause?