Exclude blanks in pie chart

[#1]

Hi again,

I have the following pie chart which includes values YES, NO and "blank".

I need that the chart takes only values Yes and No and it exclude the "blank" values.

How I can do that?

Thanks in advance

[#2]

It's a simple count(KPI_1) which has three possible values: YES, NO, Blank.

I need only count(YES, NO)

Thanks

[javier_florian]

Hi Nancy,

Edit your group, and change your dimension to:

=If(Not IsNull(Accomplishment),Accomplishment)

-JFlorian

[javier_florian]

In relation with

Count({$<Accomplishment-={''}>}value)

Value is your metric KPI_1

-JFlorian

[jerem1234 · Accepted solution]

Try:

count({<KPI_1 = {'=len(trim(KPI_1))>0'}>}KPI_1)

Hope this helps!

[jaimeaguilar]

Hi, I put "value" as a field, because I didn't know what is your expression, just replace the word value with the name of the field you're using.

I guess that your expression is something like count(distinct KPI_1), am I right?

regards

[#7]

Thank you!!!

[#8]

Thanks Jaime,

I did it with:

count({<KPI_1 = {'=len(trim(KPI_1))>0'}>}KPI_1)

See you

[rogerioqv]

Nancy,

Probablemente hay un nulo dado en su tabla. Tenemos que eliminar los datos de su dimensión. Hacer ver si los datos es nulo o no en su dimensión.

Saludos.

[#10]

Muchas gracias Rogério, ya resolví el problema.

Saludos

Nancy