Include a Billboard Column Summary

You can summarise columns with a double, float or decimal data type. The summary can be the weighted average, the mean, or the total.

You can only include a column summary for SQL-based billboards because the list of columns in the Configuration tab is required.

If you group the billboard data by column, the grouping displays the weighted average for each group of records.

If you pivot the data, the pivot value inherits any weighted-average configuration; that is, all instances of the pivoted values in each pivot column display a weighted average.

Security Note: You need the Allow billboard maintenance security right in the Billboards domain security rights group for this activity.

Activity Steps

1. Open the Billboard (configuration).
2. Select the Configuration tab.
3. Configure grouping:
   1. Select whether to Allow Grouping. If checked, you can group billboard data by dragging column headings to the grouping area.
   2. Select the Summary Row Visibility from Both Child Groups and Top Level, Child Groups Only and Top Level Only.
4. For each column to be summarised:
   1. Check Show Column.
   2. Select the Summary Method from None, Weighted Avg, Mean Avg or Sum.
   3. If the Summary Method is Weighted Avg:
      1. To calculate the weighted average based on wet mass or financial data, select the Weighting Column.
      2. To obtain a weighted average based upon the analyte basis of the analyte:
         1. Select the Weighting Column to use if the analyte has a wet basis.
         2. Select the Dry Weighting Column to use if the analyte has a dry basis.
         3. Select the Weighting Averaging Analyte Column. If the data has been pivoted, this column contains the name of the column that holds the analyte definition ID used to determine if the weighted-average calculation should use wet or dry mass to calculate the average.
5. Click Save.