Skip Blank or Null Values in Chart

[#1]

Hi.

I need to make a chart showing me the % of each letter , however in my BD SQL Server I have records in Blank, so when graphic shows me a column without a title on the chart, and that I need not see, I need skip all blank record of my calculations.

Example:

I use de cake chart, in the Dimensions i have:

and in the expression a use:

Your help please.
Thank you.

[sunny_talwar]

Try this as your calculated dimension:

If(Len(Trim(PREGUNTA615_12)) > 0, PREGUNTA615_12)

[krishnacbe]

Hi,

Check the "Suppress When Value is Null" option in Dimension Tab for PREGUNT625 Dimension.

[Gysbert_Wassenaar]

Then that blank value is probably a space or an empty string. You can try something like =Count({<Segmento={"=Len(Trim(Segmento))>0"}>}PREGUNTA612_12) to hide that value.

[#5]

It does not work , I remain exactly the same, only me ordered from oldest to youngest .

[#6]

I have that option enabled and it does not work .
Thank you

[#7]

is correct, the value I have in my BD is an empty string .

Try to apply your code in Expression But I did not work or I'm misapplying .

Thank you

[Gysbert_Wassenaar · Accepted solution]

Ah, I see what happened. I used the name of your expression label instead of the name of the dimension. Try

=Count({<PREGUNTA615_12={"=Len(Trim(PREGUNTA615_12))>0"}>}PREGUNTA615_12)

[sunny_talwar]

Would you be able to share a sample to show the issue?

[#10]

thanks gwassenaar‌ I Apply Your Solution and run!