6 Replies Latest reply: May 30, 2016 3:07 PM by Michele Van Laningham RSS

    Creating a measure based on set time periods.

    Michele Van Laningham

      I am trying to create a measure for 3 gauge chart showing me % on time deliveries. A gauge chart for each time period of 1,4,13 weeks). 

       

      Here is my calc:

       

      count of items classified as On Time/count of total population during reporting period)*100

       

      My thought process was the following:   (which is giving me an error). !

       

      sum(Count([Rct_Date]-[Del_Date]<=0)) / (sum(total(Count(Rct_date))))

       

      Then qualify by the time period I need and use each measure based on it's time period in the appropriate gauge chart.

       

      Any help would be greatly appreciated!