How to filter out the null values in X-axis for Bar chart in Spotfire

Question

I am working with a data set where I have few columns with few null values in those. When I try to plot bar chart with these columns on x-aixs it is showing separate bar with this having no name.
Is there any way we don't show the null values in the columns as Bars.

enter image description here

Please look into the image attached, I don't need to show the first bar with no name on X-Axis.

How your question is related to c# and ironpython? Have you tried filtering on the column in the x axis excluding blanks? — Máté Juhász, Feb 24 '16 at 07:24
Hi Mate, In spotfire we can include iron python and C# to Customize Visualizations — sofuser9, Feb 24 '16 at 08:26
if you are interested only in solutions with coding and not with manual selection, then please specify that in your question. — Máté Juhász, Feb 24 '16 at 08:46

score 1 · Answer 1 · answered Mar 11 '16 at 09:31

1

Alternatively to TWAndrews' suggestion you can also filter in the appropriate graph by going Right Click > Properties > Data > Limit Data using Expression: [Column name] Is Not Null

answered Mar 11 '16 at 09:31

k88

1,858
2
12
33

score 0 · Answer 2 · answered Mar 09 '16 at 04:53

0

Filters, which are tied to columns both in the GUI and API, include an option to exclude empty values. Select the appropriate value for your use case.

answered Mar 09 '16 at 04:53

TWAndrews

113
1
4

How to filter out the null values in X-axis for Bar chart in Spotfire

2 Answers2