Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-10259

INF-12207 Add Percentages to Forecast Graph

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: None
    • Fix Version/s: CFA 2020R4
    • Component/s: None
    • Labels:
    • INF Reference Number:
      INF-12207

      Description

      Configuration of Help Text

      Help Article Title: Forecast Accuracy
      Short description: Forecast Accuracy = 1-(ABS(ActualSales - ForecastSales)/ActualSales)) * 100
      External URL: leave empty
      Menu Items:

      • MxConnect - Forecast - Sales (/Forecasting/View?metric=sales)
      • MxConnect - Forecast - Transactions (/Forecasting/View?metric=transactions)

      Feature

      CFA would like to add a change percentage to the forecasting graphs when applicable.

      Example

      Image 1

      Image 2

      Calculation

      (Forecast - Actual) / Actual




      Unsolicited Note

      This formula comes from the example given in the CFA ticket (Image 2) but it seems like the percent change number that is more effective is the (Actual - Forecast) / Forecast number. If we were to calculate the percent change from the forecast value the number, in Image 2 would be -32.9% as the actual sales were smaller than the system forecasted value. My thought here is the user is looking at the forecast and trying to determine if the actuals were more or less instead of looking at the actuals and measuring the forecast.

      , IRD Link

      https://docs.google.com/document/d/130D62Cqnxk1UGeI7ajKIpOF1oeUAcPz49HCp5QZBspY/edit?usp=sharing

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason.powell Jason Powell
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.