I’m trying to create a dashboard to evaluate the accuracy of our forecasts. Well, actually, the accuracy of our customers’ forecasts. Our Customers supply us with monthly forecasts, so we have our forecast window set as 0 days before and 30 days after.I think my main question at this point is what happens to the extra days?For example:A forecast for 100 pieces gets entered on March 1st and April 1st. The customer buys 25 on Mar 7, 14, and 21.That leaves 25 balance for the March forecast. If the customer takes these on the 30th, that would consume the entire forecast.What happens if the customer takes the parts on the 31st?What I’m seeing, is the last 25 getting applied to the April forecast, but I don’t think that’s right.
I’ve created a fairly simple dashboard with 4 panes. The first pane is a date selector; 2 dates, start and end. The next pane down shows all of the jobs completed within the dates. It also shows the estimated and actual total setup and production times, The third pane down shows the operations and totals for each operation for the job selected in Pane 2. Lastly Pane 4 shows the labor entries for the selected op from pane 3. (The publish/subscribe works perfectly)I have another similar dashboard the has a Part Number prompt. Pane 2 shows each job for the part, pane 3 shows the operations and Pane 4 shows the labor entries. We don’t often need to see all of the historical data, so my thought was to add a tab to the date selected dashboard and add the Part selected dashboard onto the second tab. I tried building the dashboard from the ground up and I’ve tried creating 2 dashboards, opening the first in developer mode, and customizing it using the sheet wizard,The problem is that, while th
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.