Managing the Data Rows in a Report

Once you've set up the data for a report, you can add row details to control what and how rows are displayed.

• Row Limit

  You can add a limit to the number of rows displayed in the report.

  Enter the number (up to 5000) in the Row Limit field in the Data area of the report builder. The default is 500. Unifyr will present a warning if your row limit is too low, which may result in data being hidden. 

  

  Note: If you reach a row limit, you can't sort by row totals or table calculations.

• Totals

  If your report includes measures, you can add totals to provide the overall count for each column that is based on a measure. Enable Totals on the header row in the Data table.

  

  The totals are displayed if you're presenting your report as a Table Chart. They're shown in the visualization and in the Data table.

• Subtotals

  If your report includes at least two dimensions, you can add subtotals to break out the information and provide context. Enable Subtotals on the header row in the Data table.

  For example, this report shows the number of new leads generated by partner, compared by the registration source of the partner. With the subtotals active, the data is broken down based on the leftmost column (Partner Source):

  

  Without the subtotals shown, the report is just a list of partners with their registration source:

  

  Notes:

  • All dimensions in the table, other than the rightmost one, will be subtotalled if the option is enabled. You may need to reorder the dimensions in your report (drag and drop) to get the presentation you want.
  • The subtotals are displayed if you're presenting your report as a Table Chart. Note: the subtotals will only show in the visualization. They aren't included in the Data table.

• Column Limit

  If your table is pivoted, you can add a limit to the number of columns displayed in the report. For information on creating a pivot table from your data, see Create a Pivot Table.

  Enter the number (up to 200) in the Column Limit field in the Data area of the report builder. The default is 50. Unifyr will present a warning if your row limit is too low, which may result in data being hidden.

  

  Note: Dimensions, dimension table calculations, row total columns, and measure table calculations outside a pivot are not counted toward the column limit. Pivoted groups count as one column toward the column limit.

• Row totals

  If your table is pivoted, you can add row totals to provide the overall count for each row, counting up each column that is based on a measure.

  For example, the pivot table in this example shows a list of partners categorised by registration source, with the new lead and registered lead totals shown for each partner/source.

  

  With Row Totals enabled, totals of new leads and registered leads are provided for each registration source. Use the arrow next to the Row Totals option to change the placement of the Row Totals column in the Data table.

  

  Note that there is a Column Limit of 3 on the table in this example, so the Row Totals columns can be seen.