Appearance
Report builder
Also known as
- New ad-hoc report
- ad-hoc report
- query builder
- pivot
- pivot table
- group by
- summarise
- measures
- aggregate
- sum
The report builder makes an ad-hoc report from any dataset you can read: list rows with the columns you choose, or group and summarise them with measures (count, sum, average …), filter and sort, pick a chart, and save the result as a report you can share and schedule. The preview updates as you change the query.
Build a report
- Open AnalyticsReport builder, or select New ad-hoc report on the Analytics overview or in the catalogue. To start from a dataset, select it on the Datasets tab of Reports.
- In Dataset, choose the data to report on (each entry shows its description).
- Choose the report type:
- List rows: in Columns, pick the columns to show, in order.
- Summarise: in Group by, pick the columns that make one row per combination (One row per combination of these columns.). Under Measures, set the function and the column of each measure; select Add measure for more. Count with All rows counts the rows of each group.
- Under Filters, select Add filter, then choose the column, the operator and the value. Add as many filters as you need; all of them apply.
- In Sort, choose the column and Ascending or Descending (empty: Default order).
- In the Chart panel, choose Show as and its columns (see the table below).
- Check the Preview: switch between Chart and Table. The table shows the first 200 rows (Showing the first 200 of n rows.).
- Select Save report, fill in the dialog and select Save report again.
The saved report opens in the builder (Edit "name") and is listed under Saved reports in Reports.
Query fields
| Field | What to enter | Required |
|---|---|---|
| Dataset | The data source. Only datasets you have permission to read are listed. | Yes |
| List rows / Summarise | List individual rows, or group and measure them. | Yes |
| Columns | (List rows) The columns to show. | At least one |
| Group by | (Summarise) The columns that define one row of the result. | Group by or a measure |
| Measures | (Summarise) Function: Count, Count distinct, Sum, Average, Minimum, Maximum; and a column. Sum and Average offer numeric columns only. | |
| Filters | Column, operator and value. Text: is, is not, contains, starts with, is one of, is none of, is empty, is not empty. Numbers and dates: =, ≠, >, ≥, <, ≤, between, is empty, is not empty. Yes/no columns: is Yes or No. | No |
| Sort | A column and the direction. In a summary, sort on a result column (a group or a measure). | No |
For is one of and is none of, separate the values with commas (a, b, c); for between, type from, to. If the server rejects part of the query, the banner Adjust the query. names the field; The preview failed. shows any other error.
Chart fields
| Field | What to enter |
|---|---|
| Show as | Table only, Bar chart, Line chart, Area chart, Donut or Figure with trend. A new summary suggests a bar chart (a line chart when grouped by a date). |
| Categories | The text or date column along the axis. |
| Values (Value for Donut and Figure with trend) | The numeric column or columns to plot. |
| Stacked | Bar and area charts. |
| Horizontal | Bar charts. |
Save the report
| Field | What to enter | Required |
|---|---|---|
| Name | Defaults to the dataset name. | Yes |
| Description | Shown under the title of the saved report. | No |
| Folder | A folder from Report folders; empty is Unfiled. | No |
| Share with roles | Roles whose members can find and run it; empty is Only me. | No |
When you edit a saved report, Save report updates it and Save as new saves a copy (named name (copy)). Save report stays disabled until the query returns rows (Build a query that returns rows first).
Drill down to the records
On the Table preview of a summary, select a row. The builder switches to a list of the rows behind that group, with a filter for each group value, so you can see which records make up a total.
Differences by role
- Building and previewing needs Permission:
reports.viewand read access to the dataset. - Saving and sharing needs Permission:
reports.manage.
Related
- Saved report
- Reports
- Schedules
- Ask: questions in plain language open their query in the builder
- Report builder (Reports)
- Dashboards
- Reports catalogue
- Dashboards and KPIs
