Category / Section
How to aggregate dimension field values in Grid widget?
Published:
In Bold BI, the grid widget doesn't support aggregation on dimension fields, by default. You can perform aggregation on non-numeric fields by creating expression with aggregation functions like COUNT and DISTINCT COUNT in the grid widget.
Steps to aggregate dimension field values in Grid
Here's an example showing how to create an expression to calculate the count and distinct count of customers using the string field named CustomerID.
- Click the gear icon in the top right corner of the focused Grid widget in the design canvas.
- Navigate to the Assign Data tab and click Add Expression.
- Create an expression field with an expression using COUNT aggregation function and another one using DISTINCT COUNT aggregation function over CustomerID field.
- Now, configure the expression fields to the grid.
Displaying COUNT and DISTINCT COUNT expression fields in Grid
Related Links
RM
