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

      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