In Futrli's reporting tool, you have the option to add comparisons. Below are some examples of data comparisons you can make when building a report widget, and how to do it.
Compare a date period against another using column formulas
Compare a date period against another using column formulas
On a table in a Futrli report you have the option to add a range of pre-built column formulas. When editing a widget, click the Columns tab.
Scroll down to the Comparison columns section.
📌TIP: There are a number of options available for further analysis of the data you're displaying. For specific variance, there is an option to look at either the difference between two periods, or the percentage difference.
Compare actual data against forecasted data
Compare actual data against forecasted data
Click the Datasets dropdown.
Select actual data and the published forecasts against which you want to compare.
You can select as many datasets as you like.
Compare a forecast against other forecasts
Compare a forecast against other forecasts
Click the Datasets dropdown.
Select the forecasts you want to compare.
You can select as many datasets as you like.
Compare actual data against last year's actual data
Compare actual data against last year's actual data
Click the Datasets dropdown.
Select Actual data and Prior year actuals.
Select the relevant date range, for example, This financial year. If you select And the prior, enter 0 next to Periods.
