Using the CFO Profitability Trend Prediction Dashboard

The CFO Profitability Trend Prediction dashboard consists of tabs which correspond to key performance indicators (KPIs). Each tab displays a chart showing a forecast of your KPIs based upon your current data.

Note: To navigate between the different dashboards, either click the relevant tab in the top header or click at the end of the dashboard title.
CFO Profitability Trend Prediction Dashboard Tabs
Tab Description
Revenue Through line charts, this tab provides a detailed forecast of the future performance of your revenue.
Gross Margin Through line charts, this tab provides a detailed forecast of the future performance of your gross margin.
Operating Expenses Through line charts, this tab provides a detailed forecast of the future performance of your operating expenses.
EBITDA Through line charts, this tab provides a detailed forecast of the future performance of your EBITDA.

Using Dashboard Charts

The trend prediction charts display the following series to visualize your data and the calculations applied to it:

 
Series Description
Actual The current performance of your KPI. Actual is represented by a solid line.
Trend Model The line of best fit based upon your current (actual) data using the same algorithm used to predict future performance. The Trend Model line provides a means of reviewing the results generated by the algorithm against current performance. This model is then applied to future (forecasted) periods. This is represented by a dashed line.
Trend Prediction The forecasted future performance of your KPI.

From Spring 2020, if no data is available for the period specified in your Actual Range Start or Actual Range End, then the chart series begin from the last period for which data is available. This condition also applies if no data is available following the selections applied in the global filter panel.

Note:

Each trend prediction chart is based on monthly periods only. We recommend that you have at least two years' worth of data for your KPIs in your org to use the CFO Profitability Trend Prediction dashboard.

Managing Filters

Your filter selections determine the data displayed for each of your KPIs within your dashboards. To hide the filters click . Click again to show the filters. To set or change your filters, use the following drop-down options:

If you want to edit the global filters which appear on this filter panel, click Edit to enter edit mode and click the global filters displayed under Filters. Click Manage Global Filters | Add Global Filter to add or remove fields from the Financial Balances dataset. You can also add custom fields to your global filters.

Note:

Special periods 000 and 101 are excluded by default in the CFO Profitability Trend Prediction dashboard.

If your calendar is configured to contain more or less than 12 periods in a year, your dashboard data will be incorrect. With the exception of special periods, Analytics dashboards only support years with 12 periods. Also, you cannot compare data for companies with different financial years.

Chart Filters

The charts displayed on the KPI tabs contain drop-down menus which enable you to change the data displayed on the time series chart.

The chart filters are:

To change the input range for the data used to calculate the time series prediction, use the following drop-down options:

Note:

When you make changes to the chart filters, ensure that you use the Save View functionality to avoid losing your settings. You can click Save View on any tab of the CFO Profitability Trend Prediction dashboard. However, the currently selected tab is the default tab for the view and is therefore visible the next time you open the view.

Configuring Your DashboardFor information about configuring your KPIs, see Setting up CFO Dashboards.