9 Replies Latest reply on Feb 26, 2016 1:32 PM by Shawn Wallwork

    What Time is x% Complete?

    David Garritt

      I have a manufacturing sorting job that runs each day and I need to calculate what time a certain percentage of work is complete.  These times will be reported in a table on a dashboard along with other information.

       

      For example, if we perform 100,000 sorts in a given day and I want to report when we were 90% complete, I'd want to know the time stamp of the 90,000 sort.

       

      Each sort is a unique record, and the time stamp is in the dimension "RunStartDate"

       

      Sample workbook is attached (hopefully it's not too big!).

       

      Thanks fro the help,

      Dave

       

      Message was edited by: David Garritt I'm a bonehead - the correct workbook is now attached.