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!