Using Aggregation Types in Bold BI Pivot Grid Widget

Bold BI’s pivot grid widget is a powerful tool for data analysis. However, it’s crucial to understand the supported aggregation types for calculated fields in this widget to ensure accurate data display.

Supported Aggregation Types

The pivot grid widget supports the following aggregation types for calculated fields:

• SUM
• COUNT
• AVERAGE
• MIN
• MAX

These aggregation types allow for a variety of calculations on your data. For instance, you can calculate a field’s sum, count a field’s occurrences, calculate a field’s average, find a field’s minimum value, or find a field’s maximum value.

Note: If use the above supported aggregation type, the pivot grid will calculate this value for each data cell, and subtotals and grand totals will also be calculated using this expression condition. If use unsupported aggregation type, the pivot grid widget will display the message “No records to be displayed”.
For more information on supporting and Unsupporting expression functions in the pivot grid, refer here

Unsupported expression functions

It’s important to note that using unsupported aggregation types for calculated fields will result in an error or no data being displayed in the pivot grid widget. Other than the supported aggregation types listed above, any additional functions will not be supported.

While these functions may work in other widgets, they are not supported in the pivot grid widget.

In conclusion, when using the pivot grid widget in Bold BI, ensure to only use the supported aggregation types for calculated fields to ensure your data is displayed correctly.