Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As the title says really!
I have a field set to a gauge in a pivot table and I'd like to hide the gauge if the value is null / missing.
I've read the Null/Nothing document but I can't spot a way to make it work from this.
The value is missing rather than null, I tried to see if making it null hid the gauge but this doesn't work
=if(len(only({<Property={'Size'}, Type={'Disk'}>}Value)) >0,(sum({$<Property={'Size'}, Type={'Disk'}>}Value) - sum({$<Property={'Available'}, Type={'Disk'}>}Value))/sum({$<Property={'Size'}, Type={'Disk'}>}Value),null())
can you attach sample ?
Vikas
attached
see it if works for you
Vikas
Hi Vikas,
Did you just suppress the dimension when Null? Sorry my main app has that, I should have said.
That works, but not once you drag the field to the top row, that is when the issue occurs
Do you want to suppress the row if the gauges are null? Then you need to make sure all the expressions evaluate to null or zero, and turn on Suppress Null Values.
OR do you want to hide gauges only if they are null, but keep the row for the other values? I don't think that is possible, but you could possibly make them disappear by conditionally changing the colour to white.
Agree with Jon
Hi John,
Jonathan Dienst <span class="icon-status-icon icon-mvp" title="Mvp"></span> <span class="icon-status-icon icon-partner" title="Partner"></span> wrote:
OR do you want to hide gauges only if they are null, but keep the row for the other values? I don't think that is possible, but you could possibly make them disappear by conditionally changing the colour to white.
That exactly, I appreciate you can suppress rows using the built in null features, but this gets shot to bits when pivoting.
Thank you for confirming it isn't possible in any standard way, I'll mess around with trying to hide it visually!