Odd SQL error message
On a simple table insight with no dimensions, only measures, when pressing the SQL button, the following message is shown:
Unsupported feature: Aggregated and non aggregated select items w/o GROUP BY
Has anyone else encountered this or have any idea why?
Update: The cause seems to be in the inclusion of a formula column from a business schema that uses the SUM function. If I remove this column from the table measures, the SQL generates without any error.