1 Reply Latest reply on Nov 7, 2016 9:40 AM by Shinichiro Murakami

    Running Total Shift Goal

    Nick Lodl

      Hello,

       

      I am looking to create a "Running Total" or Aggregate Goal vs Actual dashboard for our operators to measure performance.

       

      Desired Result:

          1. Chart that displays the goal  Monday-Friday, but actual output displays Sunday through Saturday (Helping to predict overtime needs)

           2. A dynamic goal that can be changed every quarter. The look that I am going for is below:

       

      I have tried to create a parameter, but the aggregate total sums to a value in the millions - the target I want is 3200. I can get the "actual" values to upload, but I cannot figure out how to limit the goal to 5 days only.

       

      Please Help,

      Nick