Create repeating sections

Use repeating sections to create duplicates of specific sections of a report to show one or more-dimension values. The data in the repeating section is sliced to match the dimensions of the section. Repeating sections can be replicated at scale to decrease the amount of time it takes to build reports.

Use the following procedures to create and configure a repeating section in a report.

To define a repeating section

1. Navigate to the section that you want to add a repeating behavior to and choose the Edit repeating section (triple panel).

2. In the Edit section pane that opens, choose ADD DIMENSION, and then choose the dimension that you want to add.

3. To add additional dimensions, repeat Step 2. You can add up to 3 dimentions in each repeating section configuration.

Considerations for repeating sections

The following limits apply to repeating sections.

• Insight visuals aren't supported for repeating sections.

• Repeating sections dimensions that are only from the last dataset that was selected for use in the analysis.

After you create a repeating section, you can define sorting and limits to the repeating section configuration. You can also use text boxes to add system parameters to repeating sections.

Define sorting in a repeating section

To define sorting in a repeating section

1. Navigate to the section that you want to add a repeating behavior to and choose the Edit repeating section (triple panel).

2. In the Edit section that opens, choose the ellipsis (three dots) next to the dimension that you want to change.

3. Navigate to the Repeating tab and choose the ellipsis (three dots) next to the dimension that you want to sort, and then choose Edit.

4. For Sort by, use the dropdown to choose the dimension that you want to sort by.

5. For Aggregation dropdown, choose the aggregation that you want to specify.

6. For Sort order, choose Ascending or Descending.

Define limits in a repeating section

You can set limits to show only a certain number of distinct dimension values for each dimension of a repeating section. You can choose to show between 1 and 1000 distinct values. The default limit is 50.

To define limits in a repeating section

1. Navigate to the section that you want to add a repeating behavior to and choose the Edit repeating section (triple panel).

2. In the Edit section that opens, choose the ellipsis (three dots) next to the dimension that you want to change.

3. For Limit to, enter the number of values that you want to limit the sorting to. You can enter a number between 1 and 1000.

Considerations for limits

The following limitations apply to limits in repeating sections.

• An instance is defined as a distinct value of a dimention or a unique combination of values of multiple dimensions.

• If the number of unique instancess for a dimension in a repeating section exceeds 1000, the PDF report is NOT generated. If this occurs, try one of the following options.

  • Define a limit for your dimension.

  • Create a sheet level filter to restrict the dimension values.

  • Use row level security (RLS) to restrict the dimension values.

  • Apply dataset filters.

Add system parameters to repeating sections

You can use text boxes to add system parameters to your paginated report's repeating section. This makes it possible to access dimensions that have been used to configure repeating sections. Repeating sections and dimensions need to be configred before you can access the dimensions in a text box. The system parameters can only be used within a repeating section.

To add system parameters to a repeating section from a text box

1. Choose the text box visual that you want, and then choose the System parameters icon in the far right of the text box toolbar.

2. From the dropdown that appears, choose the parameter that you want.

The image below shows the System parameters dropdown in a text box.

Add page breaks to repeating sections

Similar to section page breaks, you can add page breaks to repeating sections.

To add a page break to a repeating section

1. Navigate to the section that contains the repeating behavior that you want to change and choose the Edit repeating section (triple panel) icon.

2. In the Repeating tab of the Edit section pane that appears, check the box titled Page break after each instance.

An instance is defined as a distinct value of a dimension or a unique combination of values of multipledimensions. If you clear the Page break after each instance checkbox, the page break is removed.