Adding data to charts and tables
Make your Reports insightful by adding Data, from Accounts, Groups and Non-financials to Formulas and custom KPIs.
Written by Ross MacLeod
Without data you’re reports won’t be especially insightful, so let’s look at how you can start adding the information you care about to your charts and tables. Discover how to:
- Add data using the search bar
- Add data in bulk
- Add custom KPIs
Adding data using the Search bar
Using the search bar you can add any data item within your selected organisation to your report. To do so, simply enter the name of the item you wish to add and then select it:
Adding data in bulk
As well as adding items one-by-one using the search bar, you can also add multiple items in bulk by pressing the see all button.
Any data saved within your account can be added in this way, from accounts, categories and groups, to non-financials, cashflow accounts and saved formulas – but data has to have been added for it to appear. If you’ve not yet added any non-financial data, you won’t find the option to add it to your report for obvious reasons!
To bulk add items, hover your mouse over the item and click the tick that appears. You can add as many items as you like in this fashion.
Adding custom KPIs
FUTRLI is business reporting without restrictions, which empowers you to drill into the data that matters to you. As well as adding groups, accounts and categories, you can also create your own custom KPIs to add to your reports. To create a Custom KPI, click the New Formula button and then select the Formula Builder.
Using the search bar, locate the items you wish to use within your formula and then select the calculation you wish to be performed, name your KPI and hit Ok to save. Top tip: You can include financial and non-financial data within the same formula, set the display type and the rounding.