How to get rid of "(Empty)" from Graphical Table

[Julia Varkey]

Created a graphical table that has percentages in three columns, however when one of the columns is blank that specific cell says "(Empty)" in the graphical table.

 

Is there anyway to get that specific cell to just be blank without saying "(Empty)".

Tried doing a custom expression using a case when and if statement however the data itself is numeric, so if I try to put an N/A or anything it errors and won't allow me to do the custom expression, because of different data types.

[Khushboo Rabadia]

Try adding THEN SN([Value],0) after your expression i.e. replacing all (Empty) values after calculationwith 0

[Julia Varkey]

Thanks for that suggesstion Khushboo. I have tried a similar statement, however I don't want it to be 0,  because there are instances in my data where the value is actually 0. I would like it to be either blank, or N/A rather than saying "(Empty)"

[Khushboo Rabadia]

You can either change entire integer column to string in order to show blank i.e. THEN SN(String([Value]),'') or just add rule in calculated value to color "[Axis.Value] is null" to white so it is not seen

 

You can also try some javascript approach. This is with cross table so for graphical table you would need to search for relevant div ids.

 

https://spotfired.blogspot.com/2019/04/remove-empty-from-cross-table-without.html