How to use Median aggregation in Bold BI

Bold BI application allows you to use Median aggregation by following these steps:

Steps to use the Median aggregation in Bold BI

1. Refer to Connecting to a data source for successful connection.

2. Drag and drop the table and click Save to save the data source as shown in the below image.

   

3. Drag and drop any Widget and click on the Assign data section.

4. Assign values to the widget as shown in the following image.

   

5. Click Setting button and click Median aggregation to get the median value for the selected column

6. Now you can able to view the median result of the measure column.

Limitations

We cannot use median function with expressions created using multiple columns. It is supported for expressions created from single column.