Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
but it won't hide the day.
Tomasz
i forgot to say to uncheck "Include zero values" option.
bu i want to keep the "start" status from the other fields, if a day has more than 1 status
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.
yes, but the status "start" is complete missing in the other dates too now.
maybe I didn't understand your data model because It should works.
'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.
ok then try with:
count( TOTAL <Day> distinct Status) = 1 and Status = 'Start'
This is working!! Cool
=if( count( TOTAL <Day> distinct Status) = 1 and Status = 'Start', 0, count( Status ) )