Count

[awilson484]

Hey All, I am struggling to come up with an expression for a KPI that is being built. The KPI will display how many individual orders are "Past Due" from their due dates. I do not need days past due, but the number of orders that are past due. 

As far as data, I have DueDate and OrderID, but do not have a master calendar set up for Date. 

[JuanGerardo · Accepted solution]

Hi @awilson484 , probably it should be something like this:

Count({<DueDate={"<$(Today())"}>} Distinct OrderID)

JG