Remove - from Bar chart dimension

[Anonymous]

Hiya

I currently get - in my bar chart because the values are not recognised.

How do i rename this to Other?

See attached pic

[sunny_talwar]

You can try something along these lines:

If(Len(Trim(Age)) = 0, 'Other', Class(Age, 20))

[MayilVahanan · Accepted solution]

Hi

Try like this

=If(Isnull(AgeRange),'Other', AgeRange)

[sasikanth]

HI,

You dont wan to show these values in chart other than specified ranges

then

check the option "Suppress Null values " in dimension tab

[Anonymous]

This is what ineeded, Thanks

[Anonymous]

Two options:

1) These are null values, you can go for Checking Suppress Null Value option

2) I am assuming you have created data bucket at script level, then you can do this as well?

If(Days>0 and Days<100, '0-100',

If(Days>100 and Days<200, '100-200',

If(Days>200 and Days<300, '200-300', 'Others') as Bucket //In last bucket IF condition mention other in Else part of IF.

[Anonymous]

Thanks Sunny again for being Helpful