Analyze your data with a pivot table or graph
Group records by up to three levels and one column, choose what to add up (count, total, hours …) and how (sum, average, minimum, maximum), drill into any figure and export to Excel.
Lesson 5 of 8 · Step by step
Step by step
Open Money → Reports → Analytics & dashboards and pick the data, for example Invoices.
/admin/insightsChoose Pivot. Under Group by, pick the rows — for a date also choose day, week, month, quarter or year.
Under Columns pick a second grouping if you want one, and under Measures what to add up; change Sum to Average, Minimum or Maximum next to a measure.
Click a number to see its records, or a row name to break it down further; Expand all / Collapse all opens or closes the levels.
Switch to Graph for bars, a line, stacked bars or a pie, or download the pivot with Excel or CSV.
Where to find it
- Money → Reports → Analytics & dashboards
/admin/insights
Checklist
Before you move on, check that you can:
- Open Money → Reports → Analytics & dashboards
- Choose Pivot.
- Under Columns pick a second grouping if you want one, and under Measures what to add up; change Sum to…
- Click a number to see its records, or a row name to break it down further; Expand all / Collapse all opens…
- Switch to Graph for bars, a line, stacked bars or a pie, or download the pivot with Excel or CSV.
Tips and common mistakes
- Amounts are in the company currency, converted with each document's own exchange rate.
- Set From and To to analyze one period only.