Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can anyone please help me on this.
In the below bar chart I need to remove the [Null] bar from the Partner Dimension.
I have to remove only from this chart in UI not from the complete app in the backend.
Please help me on this.
Thanks in Advance.
Use as a dimension
=if([Partner Dimension] = '[Null]', null(), [Partner Dimension])
and then uncheck the box "Show null values" on the dimension
Use as a dimension
=if([Partner Dimension] = '[Null]', null(), [Partner Dimension])
and then uncheck the box "Show null values" on the dimension
Hi,
try below methods,
Method 1) Try to suppress null value from your dimension field "Partner"
Method 2) try to exclude null using set analysis expression
let say you have measure as Sales then
sum( {$<Sales={">0"}>}Sales)
or
sum( {$<Partner={"=Len(trim(Partner))>0"}>}Sales)
Thanks,
Deva