Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have an incomplete dataset whereby I have sales by salesman but then I have sales not done by any of my recorded salesmen.
For example,
Mr Smith has £3000.00
Mr Jones has £5004.50
Mr Thomas has £9000.21
Mr Taylor has £203.99
then empty value has £9000000.32
How would in a bar chart I be able to ignore the bar chart representing the empty value?
Thank you
Go to your Script and instead of salesman, write below expression
If(Len(Trim(salesman))=0 or IsNull(salesman), Null(), salesman) as salesman,
Now
Go to dimension tab of your Bar Chart
and tick Suppress when value is NULL
Go to your Script and instead of salesman, write below expression
If(Len(Trim(salesman))=0 or IsNull(salesman), Null(), salesman) as salesman,
Now
Go to dimension tab of your Bar Chart
and tick Suppress when value is NULL
Thank you.
I tried out the isnull statement but that didn't work, but the length of the trim worked