Show list of fields without using filter

[Anonymous]

Hello! I have a doubt.

I have a field called 'Problema'. This is a text field. I show you here:

There is another field called 'Estado', that shows 'Open' or 'Closed'.

I want to show just Fields who are 'Open' , without a filter. I think I have to use Set Analisys, But I don't know the expression.

I only have to use Year and Month Filter. Now, It shows me all the fields that are from the year and month respectfully.

But I just want to show these 7 fields:

[ishanbhatt · Accepted solution]

Hi Frantz,

In your case, you can apply IF condition in the dimension.

Something like this,

=if(Estado='open',Estado)

and uncheck the Include null values option.

I've also attached example app. Hopefully, this will help you.

[Anonymous]

Thanks Ishan! It works