Business calculations without including used elements in output

When using business calculations, it would be useful if the dimensions that were referred to in the business calculation were not included by themselves in the query outside of the business calculation itself. Instead, the business calculation can be used as a custom dimension itself.

Example Business calculation name ‘Sale Type’

case(
when: price >10
, then: ‘>$10’
, else: ‘<$10’
)

output would be

Sale Type Sales

$10. 803
<$10. 209

Not

Sale Type Sales

$10. 1
$10. 1
$10. 1
<$10. 1
$10. 1
$10. 1
<$10. 1

etc.

Hi Alex,

This behavior of business calculation is aimed to support cases when calculating the total average or total median, etc.
Therefore, the business calculation is currently executed after pivot so that is the reason why your values are not automatically grouped into one.

We totally understand that the behavior is unexpected but this is something that we’re planning to improve in the future. My apologies for any inconvenience.
As a workaround, you need to create the field in the data model instead of in the report level.