Pivot tables and graphs: how it works
The pivot and the graph add up any source by up to three row groups and one column group, with several measures (count, totals, tax, hours, value …) as sum, average, minimum or maximum. Click any figure to see the records behind it, and export the pivot to Excel or CSV.
Lesson 2 of 8 · How it works
How it works
In «Group by» choose what the rows are (status, customer, branch, a date by day, week, month, quarter or year …). Add up to three levels; each level has its subtotal and can be collapsed.
«Columns» (pivot) or «Series» (graph) splits every row by a second dimension; «Swap rows and columns» turns the table around.
«Measures» decides what is added up; next to each, choose sum, average, minimum or maximum.
Click a row label at the deepest level for «Break down by …», or a number to open the list of exactly those records.
The graph draws bars, a line, stacked bars or a pie; more than five series are folded into «Other», and «Show the figures as a table» lists every value.
Amounts are converted to the company currency with each document's own exchange rate (today's rate for till sales, payments and deals, which store none). Dates are grouped in the company time zone, so an invoice issued at 01:30 on the 1st belongs to that month.
«Excel» and «CSV» download the pivot with the row and column totals; money is in the company currency.
Where to find it
- Money → Reports → Analytics & dashboards
/admin/insights
Settings that change it
- Settings → Finance & documents → Currency & tax
/admin/settings/finance?section=currency - Languages & currencies (exchange rates)
/admin/localization
Checklist
Before you move on, check that you can:
- Open Money → Reports → Analytics & dashboards
- In Group by choose what the rows are (status, customer, branch, a date by day, week, month, quarter or year…
- Columns (pivot) or Series (graph) splits every row by a second dimension; Swap rows and columns turns the…
- Measures decides what is added up; next to each, choose sum, average, minimum or maximum.
- Click a row label at the deepest level for Break down by …, or a number to open the list of exactly those…
Tips and common mistakes
- A selection of more than 100,000 records is cut there and the page says so — narrow the period or add a filter for exact figures.
- Results are kept for one minute; after a change, the figures refresh within a minute (moving a Kanban card refreshes them at once).
- Draft and void documents are counted like the list shows them: filter by status to leave them out.