A scorecard helps to answer "how are we doing?" You can add a scorecard to a dashboard to present business performance in a concise visualization.
In this walkthrough, you will create a production scorecard by changing the default scored template:
Before You Begin
Learn more about the scorecard template and default settings.
- Required Permission: Access Discovery.
- Edit access to a shared perspective.
This example uses the Working Budget as the default version and the following accounts and dimensions:
- Columns: Revenue Cube account
- Rows: Location dimension broken down by Group dimension
You will learn how to create three sections with columns that visualize plan-to-actuals for the current period, year-to-date, and a forecast. This walkthrough uses the default version Working Budget, Actuals, and Forecast and the following custom account, operational metrics:
- Overall Equipment Effectiveness
See Scorecard Settings for description of appearance, data, and time settings.
Your versions and data sources may be different than the ones illustrated in this example.
How You Get There
From the nav menu, click Discovery to display the Perspective Overview.
Navigate to the perspective and dashboard click to create a chart.
Create a Scorecard
These steps explain how to create a scorecard and add an account to the chart. After completing these steps, the scorecard will look like:
- Create or navigate to the perspective and dashboard for the new chart and click on the toolbar to edit the dashboard.
- On the left panel, click to choose a chart. Drag and drop to add the scorecard to the chart editor.
- Click to choose accounts. Drag and drop the Custom > Operational Metrics > Availability account to the scorecard.
- In the right panel, click to edit Appearance settings.
- Expand the General section and change the name to Production Scorecard.
Change the Scorecard Sections
In this step, you reorganize the scorecard:
- Remove the micro chart column from the month section.
- Delete the quarter section.
- Change the data range of the Year section.
- Add a section for forecast.
After completing these steps, the scorecard will look like:
Remove a Column from a Section
- Click the Appearance Settings tab , expand Sections, and expand the Month section.
- Click the X next to the Micro Chart column to delete it:
A confirmation displays
- Click Ok to confirm. The column is removed from the section.
Remove a Section
- Click X next to the Quarter section:
A confirmation displays.
- Click Ok to confirm. The quarter section is removed from the chart.
Change the Data Range in the Year Section
You will change the Year section to show year-to-date.
- In the right panel, expand the Year section, and rename the section to YTD.
- For each column in the Year section, expand and change the Data Range to To Date.
The chart displays the YTD section name and the date format for the Actuals and Budget columns changes to 2019 PTD to indicate to-date data.
- In the YTD section, change the data range and format of the micro chart:
- Time Alignment: Trailing
- Period Count: 12
- Period: Month
- Chart: Line
Add a Section to Show a Forecast and Finish
You will add a single column section that represents a forecast. As a last optional step, add two more accounts. After completing these steps, the score will look like:
- Click the New Section icon to create a new section:
- Expand the section and rename to Forecast.
- Expand the column, Value. Change the following settings to show the forecast for next year:
- Version: Forecast
- Time Alignment: Next
- Period: Year
- Offset Count:1 (sets the relative period to 1 year in the future based on the current period)
- Keep all other defaults
The column header in the chart changes to <YYYY> Fcst.
- Optionally add few more data series, such as Downtime and Overall Equipment Efficiency. Two ways to add more data series:
- From the Data Settings tab, Click the Add icon and select an account.
- From the Accounts tab in left panel.
You can always add all data series when you first create the scorecard. For your first scorecard, start with one data series to reduce clutter and help you focus designing the chart. Once you get close the final design, add the other data series.
This completes this walkthrough.