When a report is broken into sections any charts associated with the report will be displayed for each section as a separate chart relating to the sections specific data.
What is a Section?
A section does what its name implies. It breaks up the data in a table or crosstab table by grouping the data into sections according to a selected value. This allows you to display all the data for each value of a dimension variable together, and more importantly, it allows you to display subtotals. The example below demonstrates how breaking up a table works.
Why use Sections?
In the example below the report on the top is displayed as a column table. The user then has to interpret the data by reading down the columns. If the report is specifically aimed at assisting the user to understand more about the company relationship then sectioning the data can make the same data easier to interpret. The example below shows how the report is now easier to read.
Breaking a report into sections is a way of spitting large tables of data into smaller, more comprehensible parts. Each section contains at least one table, and at least one section cell, as illustrated above.
Adding a Section
Single Section Breaks
To create a section, just drag an item from your report data field list or move an item from an existing column in the report.
In the example below the Athlete Region is dragged from the column fields to the report sections box. This will split the tables on the report into one section for each Athlete Region.
Note: You can only add dimension data into the report sections. The use of metric data is not supported for sections. If you do attempt to add a metric to the section edit box the following error will be displayed:
Adding Multiple Sections
You can insert any number of section breaks on a table or crosstab table. When you have more than one section in a table or crosstab table, the breaks are assigned levels. Yellowfin assigns level 1 to the first break you insert, level 2 to the second and so on. You can rearrange these levels in the Report Section Edit box.
Changing Break Order
- Select the field that you wish to change the order of.
- Drag and drop that item to the position in the list that sets the order you require.
Deleting a Section Break
- Click on the section field you wish to remove
- Once highlighted, drag off to an area that can't contain a field
Sections & Charts
In the example below a separate chart is displayed for both the Female and Male sections.