Show only two companies from dimension

[#1]

Guys,

I have a dataset in which I have data of several prijsclasses (the columnname is called ->marktplaats_prijscategorie): 1,2,3,4,and priceclass 'NA'. I would like to exclude the NA priceclasse in the table.

So therefore I tried to make a calculated dimension with this expression:

          {$<marktplaats_prijscategorie =-{'NA'}>}

But there seems to be an error in my expression. Any thoughts on what im doing wrong here?

[Anonymous]

just Switch  the sign =- to -=

  {$<marktplaats_prijscategorie -={'NA'}>}

[sunny_talwar]

What you have can be used in expressions, for calculated dimension, try this:

If(not Match(marktplaats_prijscategorie, 'NA'), yourDimensionName)

[#4]

Thanks for your answer.

However I still see a spike in my graph that I dont want (see attachment)

Any thoughts on how I have to get rid of this?

[#5]

i want to have it like  this:

[NareshGuntur]

Don't use Calculated Dimension. Use the field as normal dimension and the same set analysis which you are using now in Dimension, use it in Expression.

Cheers,

Naresh

[sunny_talwar · Accepted solution]

You need to select 'Suppress When Value is Null' on the dimension tab of the chart properties to fix that

[#8]

Sweet @Sunny_T thanks!