Remove blank space between the missing values in a bar chart

[#1]

hi all,

I trying to build a bar chart with 2 dimensions and counting IDs, the requirement is to not show the empty space in bar chart if value is missing,

attached are the screen shot of the data and bar chart.

thank you in advance.

[NickHoff]

On the presentation tab make sure Suppress Zero-Values and Suppress Missing is checked.

[#3]

hi Nick ,

the options are check marked in presentation tab but its not working.

[NickHoff]

If that is the case then the fields aren't actually null or missing then it's an issue with how you are building the table.

[sujeetsingh]

I will suggest you to use the Stacked style of the chart

[Anonymous]

You cannot.  But you can use pivot table with colors - see attached.

[ashwanin]

Hi Sanket,

I don't think its possible .but  if you do a little change in the  bar chart, then it will not reflect your blank field ref Qvw.

[saurabh5 · Accepted solution]

hi Sanket,

if you dont want to use sttacked bar chart, there is a work around, if you seperate out your home type dimenssion into 3 different fields like:

if(hometyp='A',1,0) as HometypA,

if(hometyp='B',1,0) as HometypB,

if(hometyp='C',1,0) as HometypC,

and then create 3 graphs with calculated dimenssion similar as shown below

=if(HometypA='1',hometyp)

and put these graphs in a container object while suppressing null values it will remove the blank space.