Forecast Your Year-End Figures with New Custom Scorecards

Last Updated: Friday, June 13, 2014 by Sofi Hjalmarsson

Over the years at Target Dashboard, we have received numerous requests for calculations and metrics to include in our scorecards, and we've now added the option to create your own, custom scorecards using a wide range of metrics and fields.

For example, you can now show Year-to-Date and a comparison to last year as well as your YTD target.


Or you could create a more traditional scorecard that shows month-on-month trend, but excludes some of the fields that would appear in one of the standard designs and include others that wouldn't, like run rate.




 

The custom scorecard option gives you the freedom to include the fields that you want to show in your scorecard, and exclude what you don’t need.




 

Below, you will find a description of all of the fields available to the custom scorecard. Please note that depending on the date grouping you are using ‘Month’ in the table below would equal Quarter, Week or Day.

Field

Description

Month Actual

The latest actual value (last complete or latest to date depending on scorecard configuration)

Month Target

The latest target value (last complete or latest to date depending on scorecard configuration)

% to Month Target

A % illustrating how far above or below target you are

Delta to Month Target

The actual figure of how far above or below target you are

Previous Month

Actual for the previous period

Previous Month Target

Target for the previous period

% Month on Month Change

% change from the last to the current period

Delta Month on Month Change

Actual change from the last to the current period

YTD Actual

Your actual Year-to-Date figure

YTD Target

Your Year-to-Date target

% on YTD Target

A % illustrating how far above or below your YTD target you are

Previous Year YTD

Year-to-Date for the same period last year

% Change on Previous YTD

% change from last year’s YTD to the YTD for the current year

Delta Change on Previous YTD

Actual change from last year’s YTD to the YTD for the current year

Run Rate

Extrapolated forecast for year-end, proportionally based on available actual figures

Trend Sparkline

A Sparkline showing trend over 12 completed periods (months, weeks, days



We’ve also created a short video on how to create a custom scorecard. Click below to watch it on YouTube!



 

As usual, if you have any questions on the contents of this blog post, or anything else for that matter, just let us know on support@targetdashboard.com.

Best regards,
Sofi Hjalmarsson
shjalmarsson@targetdashboard.com