Calculating Averages in Bold BI Using Expressions

In some cases, you might notice that the Average function is not readily available in Bold BI. Instead, you might only see options for Sum and Count. However, you can still calculate averages by using expressions.

By using expressions, you can create a new column that calculates the average of other columns. This gives you the flexibility to perform more complex calculations and analyses in your Bold BI dashboards and reports.

Once the expression is added click Save and Close this dialog. A new expression column will be created now and that can be used further in your dashboards.

Additional References

• Configuring Expressions in Bold BI
• Best Practices for Handling Aggregated Expressions in Bold BI