How to start calculate & display KPIs like Installation Rate

[bvmike2001]

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

[giakoum]

please see attached example :

F1: order_id

F2: order_status

[bvmike2001]

Many thanks Ioannis!

And how to exclude from the Total amount of orders the orders with Order_status=Unvalidated?

[giakoum · Accepted solution]

Count({$<[F2]={"Finalized"}>} F1) / Count({$<[F2] -= {"Non-validated"}>} F1)