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,



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