Skip to main content
All CollectionsReportingBuilding a report
Display actual or historical data on a report
Display actual or historical data on a report

How to view actual and historical data in a report.

Updated over 7 months ago

When you build your own widget, you have three options for the type of data you can view in a report when building a widget:

  • Actual data - This is your actual known data up to today's date

  • Prior year actuals - The results from the same time last year

  • Forecast data - The figures created from a published forecast

When reporting on a mix of actual and forecasted data, your options will depend on the type of forecast you select.

1 year P&L only

This will display forecasted data. For any periods not covered by the forecast, no data will be displayed.

3 year cash flow

With this forecast, you can control when actual data shows until, then when forecasted data shows from. You can do this within the forecast itself.

3 year cash flow with due invoices

This forecast option will always display actual data until yesterday, then forecasted data moving forward.

Did this answer your question?