Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Julia Varkey

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...