Suppress 0 in the Spotfire visualization
venkatesh selvaraj
Is there a way to suppress value 0 in the visualization. My visualization has so much of data and our business team doesn't want to display value 0 in the visualization. is there a way to suppress it. Attaching below the Original output and expected output. 
Thanks Venkatesh
niko
you can "hide" the zeros by creating a calculated column with the following expression:
If([Fruits] = 0, NULL, [Fruits])
but you have to do this for each column you wish to "hide."
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: could not cast the value of type 'swift.bool.type' to swift.bool
- Next: Why doesn't "(value) != range(0,256)" detect values outside the range 0-256?
Related
Related Related
- 1
Spotfire Ironpy how to edit specific visualization
- 2
Max Date Function in Spotfire Visualization Title
- 3
Displaying zero values in spotfire data visualization
- 4
Suppress 0-values in ggplot
- 5
How can I automatically use values from a higher-lever(master) visualization when creating a lower-level visualization (details) in Spotfire?
- 6
How to add/remove columns in CrossTable visualization in Spotfire using IronPython script plugged to button?
- 7
Spotfire Plugin Cache Settings, visualization not loading correctly in web interface. Any advice?
- 8
How to suppress infinite loop note when using "IF 0 THEN SET"
- 9
Google Visualization-Invalid row type for row 0
- 10
How to suppress the error message when dividing 0 by 0 using np.divide (alongside other floats)?
- 11
C++ std: Making a polynomial class, how to suppress all 0 coefficients that the user inputs?
- 12
K.gradients(loss, input_img)[0] return "None". (Keras CNN visualization with tensorflow backend)
- 13
Spotfire limit data by text
- 14
Spotfire Scripts not trusted
- 15
Spotfire - Line chart
- 16
Spotfire SaveAs using ironPython
- 17
Cross table in Spotfire
- 18
Spotfire Export Automatically
- 19
Cross table in Spotfire
- 20
TIBCO Spotfire logs export
- 21
fill the Null place in Spotfire
- 22
Spotfire - Finding Percentage of Subtotals
- 23
Spotfire Information Link Filters
- 24
Implementing Javascript in Spotfire
- 25
Changing column values in Spotfire
- 26
Calculations within a spotfire column
- 27
Visualization with Dart?
- 28
Visualization - Tableau
- 29
Visualization of graph
Comments