How to hide specific values in a stacked bar chart?

[#1]

Hello Community,

i have created a stacked bar chart where i have different "status" for different "days".

I dont want to show if a day has only the status "start" like the 30.04.2016 in the picture.

How can i hide this?

Tank you really much for your help!

Greetings,

Florian

[tomasz_tru]

but it won't hide the day.

Tomasz

[agigliotti]

i forgot to say to uncheck "Include zero values" option.

[#4]

bu i want to keep the "start" status from the other fields, if a day  has more than 1 status

[agigliotti]

yes that's why I wrote as below:

count( distinct Status) = 1 and Status = 'Start'

it means only Days with only one status equal to 'Start' will be hide.

[#6]

yes, but the status "start" is complete missing in the other dates too now.

[agigliotti]

maybe I didn't understand your data model because It should works.

[tomasz_tru]

'count( distinct Status)' in condition will be calculated for every dimension value - so it would be 1 for every day - that's why 'Start' disappeared.

[agigliotti · Accepted solution]

ok then try with:

count( TOTAL <Day> distinct Status) = 1 and Status = 'Start'

[bharani8]

This is working!! Cool

[bharani8]

=if( count( TOTAL <Day> distinct Status) = 1 and Status = 'Start', 0, count( Status ) )