Passer au contenu principal


Workday Adaptive Planning Knowledge Center

How Is The Trend Calculated On A Scorecard?

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.


How is the trend calculated on a Scorecard?


The trend calculation is based on the start and end points of the Micro Chart Trendline in the dial rather than start and end points of the Micro Chart. To turn on the Micro Chart Trendline, users can take the following steps.

  1. Go to the Visual Designer in Discovery
  2. Select the Scorecard dial
  3. Click on the Analysis Settings
  4. Select Micro Cart Trendline in the Default Analysis View field 
  5. Save

The Micro Chart Trendline shows the value of the linear regression over time. After displaying the Micro Chart Trendline in the dial, users can find the start and end values by hovering the pointer over the trendline at each end (see screenshots). Be careful not to select the Actuals values line in the micro chart. The calculation to find the trend is below.

Trend = div((End Point - Start Point),Start Point)

In the example in the screenshots belo, we are viewing the trend over 12 months. The starting value of the Product GM% Account trendline is 77.4%, and the ending value of the trendline is 106.7%. Using the trend formula, we are able find a trend of 37.9%. This value displays when hovering over the trend icon.

  • Cet article vous a été utile ?