Add elements and data to a report (Beta)
This documentation describes one or more public beta features that are in development. Beta features are subject to quick, iterative changes; therefore the current user experience in the Sigma service can differ from the information provided in this page.
This page should not be considered official published documentation until Sigma removes this notice and the beta flag on the corresponding feature(s) in the Sigma service. For the full beta feature disclaimer, see Beta features.
Once you have created a report, you can add elements and data to start building out your report. After adding data, you may also want to paginate table elements for ease of use and understanding. This document covers how to add elements to your report, and paginate tables and pivot tables.
Once you have added elements to your report, you may want to further customize element size and formatting. See Customize report settings and themes (Beta). For more information on reports in general, see Reports overview (Beta).
User requirements
- To add elements to a report, you must be assigned an account type with Create, edit, and publish reports permission. See Account type and license overview.
- You must be in Edit mode.
Add elements and data to a report
Each report page provides a canvas on which you can add and arrange elements. You can add a variety of different element types:
- Data elements, like tables, charts, and pivot tables. See Create a data element.
- Input elements, like empty or linked input tables. See Intro to input tables.
- Control elements, like filters and inputs. See Intro to control elements.
- UI elements, like text, images, buttons, embeds, dividers and page numbers. See Intro to UI elements and Edit page setup, order, and number (Beta).
Once you have added elements to a report, you can format them to meet your reporting and branding needs. See Format report elements, themes and branding (Beta).
Paginate or collapse data tables in a report
Make your data easier to navigate by paginating table and pivot tables. There are two ways to paginate data tables:
From the table element:
- Select your desired table.
- At the lower right corner of the table, select Expand table.
- To collapse the table, select Collapse table.
From the editor panel:
- Select your desired table.
- In the Format tab of the editor panel, open the Size section, then select Expand table rows.
- To collapse the table, unselect the Expand table rows checkbox.
Pagination limitations
- Tables and input tables can be paginated up to 10,000 rows:
- This limitation applies to how many rows are rendered in the report. All operations (like filtering, formulas, summaries, and any child element interactions) are performed on the entire dataset.
- Report exports will display up to 10,000 rows of data per table/input table.
- Only vertical pagination of data tables is available. Horizontal pagination is not supported.
Updated about 9 hours ago
- Tutorial: Build and export a sales report (Beta)
- Create and edit reports (Beta)
- Edit report page setup, visibility, and numbers (Beta)
- Customize report settings and themes (Beta)
- Customize text typeface, size, and style in reports (Beta)
- Customize element size, position, and layering (Beta)
- Share and export reports (Beta)
