Table Block Configuration

Updated by Niki Budd

Table Block Configuration

Coming soon to Healthy Roster 2.0!

Sorting and aggregating data in your reports will enhance your ability to visualize, organize, and ultimately make more effective data-driven decisions.

Video Tutorial:
Step-By-Step Tutorial:
Note: this tutorial will show you how to from using a blank template; the actions will apply if you're adding a block to an existing report or template
  1. From edit mode, select +
  2. Select Table
  3. Now select to add your data source. The data source will provide a different way of grouping information from the system. Select OK.
Note: follow along with Advanced Data Source Topics for further information
  1. Begin to complete the configuration screen.
    The title is required, but does not need to be visible
  2. Next, navigate to the column tab to configure which columns you'd like to display
  3. Select all to include all, or singularly include what you'd like to include by checking the independent boxes.
  4. Drag and drop the item within the list to reorder
  5. Edit the behavior of each column within the table by selecting the edit icon for that column
  6. Edit the column's configuration as necessary, select OK once desired changes have been made

  1. Select the data tab to continue to configure your table
  2. To see your data in standard format, select which column you'd like to sort by and select OK
  3. Adjust the position and size of your table as you wish
  4. Reset the report parameters and select refresh
  5. To edit the column width, you can navigate back to edit more or drag and drop the column to the proper width
  1. If you wish to group or aggregate, navigate back to your table edit screen by selecting the edit menu for the table.
  2. Now select Edit
  3. Select the Group By dropdown
  4. Select the desired data point

  1. Select OK
  2. Select Refresh to refresh your edit mode
Note: The count will correspond to the total number of rows in that grouping
  1. You can add additional grouping as well; follow along with steps 15-19 to add another grouping
  2. Select Refresh to see your double grouping
  3. Next lets, apply aggregation to your data begin in your tables edit menu
  1. Now select the Aggregate By drop-down
  1. Select the desired option
Note: if you select a non-number-based field, you will only be able to aggregate by count
  1. Select your aggregation filter
  1. Select OK
  1. Select to refresh your parameters; take note your sum will now be listed at the bottom of your table.
Next, we recommend - Pie Charts


How did we do?


Powered by HelpDocs (opens in a new tab)