Text Box based on calculated field

Question & Answer
1

Hi!

I want to create a visual that displays a calculated field as a string. However, I am not able to do that. Here is an example of what I want to do.

Calculated Field:

ifelse( 
        {Count_pt}>0, 'Portugal',
        'Spain'
      )

Then I want to create a visual that displays ‘Portugal’ or ‘Spain’ based on the condition of the calculated field.

How can I do this?

Thank you in advance :blush:

2

is count an aggregation?

You might looks to do a pre_agg calculation.

For more information you can check out this blog.

3

hi @jcatulo - we tested your provided calculation and it is working fine in the report at the aggregated level.

image

You can just create calculated field and invoke it in the report.

Thanks!

1 Like