3 Replies Latest reply: Aug 7, 2012 10:09 AM by ioannis giakoumakis RSS

    How to start calculate & display KPIs like Installation Rate

    Mihai Coroi

      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'