Null values in a calculated dimension

[#1]

Hi is there a way to drill down into the null values in a chart which uses a calculated dimension. I have a pie chart with the following dimension which picks out only the values labelled 'High' and 'Low'. I want to be able to drill into the rest of the data which doesnt have a TAX_BAND assigned.

=if(not wildmatch(TAX_BAND, '*Low*', '*High*'), null(), TAX_BAND) as NEW_TAX_BAND

[sunny_talwar]

May be don't make it null() call it NULL

=If(not WildMatch(TAX_BAND, '*Low*', '*High*'), 'NULL', TAX_BAND)

[#3]

Thanks Sunny. It doesnt seem to like that expression. Throwing an error.

[trdandamudi]

Give a try on the below for calculated dimension:

=If(Len(Trim(TAX_BAND))>0 ,TAX_BAND,'Null')

[sunny_talwar]

What is the error that you are seeing?

[#6]

'Error in calculated dimension' appears in pie chart

[sunny_talwar]

Would you be able to share a snapshot of the expression you used for the dimension?

[#8]

I beg your pardon. That works now. However I see both 'NULLS' and a separate chunk in the pie chart which is all values with a TAX_BAND assigned aside from the ones picked up by the wild card. Ideally I want to see only 3 chunks.

High

Low

NULL ( ie those values with no tax band assigned )

[trdandamudi]

Please check the expression that Sunny provided and it is working. Please see the chart below with Sunny expression:

[sunny_talwar]

How about you try this (I removed not before WildMatch and changed the order of True and False):

=If(WildMatch(TAX_BAND, '*Low*', '*High*'), TAX_BAND, 'NULL')