1 Reply Latest reply on Jan 4, 2019 4:43 AM by Zhouyi Zhang

    Completion rate calculation

    Ravikiran Sarala

      Hello all,

       

      I have scenario where i need to calculate

       

      rolling 12 months records with months on X axis and no of records on Y axis. and completion rate of those records in the dual axis as shown below.

       

       

      Here for over due completion rate calculation(which is in green color) is calculated using COUNTD([Overdue Actions])/TOTAL(COUNTD([Action ID]))

       

      which means over due actions for month divided by total no of actions before today(). But does not make sense cal % of over due actions for month of march 2018 with all the actions until today.

       

       

      What i would require is over due actions for that month divided by total over due action till that month

      like (over due actions for May 2018)/(total over due actions till may 2018)

       

      Due to compliance issue cannot attach the workbook. you can take sample superstore.

       

      Thanks & Regards,

      Ravikiran S