Suppress a dimension label when expression is null

[steveniow]

Hi,

I am trying to create a chart in a trellis with multiple dimensions, however not all of the values I need are populated on each day I have in the trellis.

How do I supress the labels where I have no data? I have tried to use an omit if null expression and it hasn't worked.

In the picture below you can see that there are several blank cloumns labelled AM, PM, EV and it is these I need to drop.

Thank you...

[sunny_talwar]

What is the expression that you are using?

[Mark_Little]

Hi,

Not best practice , but you can use a calculated dimension.

If(ISNULL(SUM(Field)) =0,dimension)

Mark

[stigchel]

Maybe these threads are helpfull as well

Getting the most out of a Trellis bar chart, some tricks

hide dimension values in trellis

[steveniow]

Thanks, this is a variation of the formula I tried but it doesn't work. I just gave it another shot with your syntax but no joy.

[steveniow]

similar to below - but I couldn't get this to work either.

[#7]

did you set the dimension to supress if value is null or 0?

[steveniow]

yes - and after a bit of playing I have a slightly different problem.

It now seems to have worked but is displaying an'error in expression' value instead of the dimension label I was expecting.

A different formula but with the same idea has given the same output... as below...

Thanks for your help - really appreciated.