Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
please, i need some help because i'm a beginner.
So my data model look like this:
- Order_id
- Order_status [Finalized / Canceled / WIP / Non-validated]
I want to calculate and display in a gauge chart let's say the Installation Rate KPI: Amount of orders with Order_status = 'Finalized' / Total amount of orders excluding orders with order_status='Non-validated'
Regards,
Mihai
Count({$<[F2]={"Finalized"}>} F1) / Count({$<[F2] -= {"Non-validated"}>} F1)
please see attached example :
F1: order_id
F2: order_status
Many thanks Ioannis!
And how to exclude from the Total amount of orders the orders with Order_status=Unvalidated?
Count({$<[F2]={"Finalized"}>} F1) / Count({$<[F2] -= {"Non-validated"}>} F1)