How to resolve group by issue when using expressions in Bold BI

Published:

Issue Description:

When an expression is created with columns that are not enclosed by square brackets and are used in the widget, the widget will throw an error as "column must appear in the GROUP BY clause or be used in an aggregate function".

Example expression:

Year(report_date)

Here, the column report_date is not enclosed by square brackets.

Solution:

When using expressions in Bold BI, it's important to ensure that the syntax is correct for the expression to work as expected.

To resolve this issue, make sure that the column names in the expression are enclosed in square brackets. The correct syntax for the expression should be: