13.5 Change the display of your table

You can customize the display of an event report.

  1. Click Options .

  2. Set the options as required. Available options are different between aggregated event reports and individual event reports.

    Event reports options

    Option

    Description

    Available for report type

    Data

    Show column totals

    Displays totals at the end of each column in the pivot table.

    Aggregated event report

    Show column sub-totals

    Displays sub-totals for each column in the pivot table.

    Aggregated event report

    Show row totals

    Displays totals at the end of each row in the pivot table.

    Aggregated event report

    Show row sub-totals

    Displays sub-totals for each row in the pivot table.

    Aggregated event report

    Show dimension labels

    Displays labels for dimensions.

    Aggregated event report

    Hide empty rows

    Hides empty rows in the pivot table.

    Aggregated event report

    Hide n/a data

    Hides data tagged as N/A from the chart.

    Aggregated event report

    Include only completed events

    Includes only completed events in the aggregation process. This is useful when you want for example to exclude partial events in indicator calculations.

    Aggregated event report

    Individual event report

    Limit

    Sets a limit of the maximum number of rows that you can display in the table, combined with a setting for showing top or bottom values.

    Aggregated event report

    Output type

    Defines the output type. The output types are Event , Enrollment and Tracked entity instance .

    Aggregated event report

    Program status

    Filters data based on the program status: All , Active , Completed or Cancelled .

    Aggregated event report

    Event status

    Filters data based on the event status: All , Active , Completed , Scheduled , Overdue or Skipped .

    Aggregated event report

    Organisation units

    Show hierarchy

    Includes the names of all parents of each organisation unit in labels.

    Aggregated event report

    Style

    Display density

    Controls the size of the cells in the table. You can set it to Comfortable , Normal or Compact .

    Compact is useful when you want to fit large tables into the browser screen.

    Aggregated event report

    Individual event report

    Font size

    Controls the size of the table text font. You can set it to Large , Normal or Small .

    Aggregated event report

    Individual event report

    Digit group separator

    Controls which character to separate groups of digits or “thousands”. You can set it to Comma , Space or None .

    Aggregated event report

    Individual event report

  3. Click Update .