Calulated Dimension - aggr giving me "-"

[zagzebski]

I have the following calculated dimension for a graph:

=aggr(only({<Year={'2014','2015'}>}Year),Year)

The problem is it give me a bar chart with 2014, 2015 but also with a bar that has " - " as a year. How can I write this so it is only 2014 and 2015 and gets rid of that extra null bar.

Thanks,

Zag

[Kushal_Chawda · Accepted solution]

for this calculated dimension check the Option "suppress when value is NULL"

[zagzebski]

Thanks. But still wondering when I set on 2014, 2015 why I would get a null "-" value also.

[#4]

if you are applying individual check out the same Option "suppress when value is NULL" as said by Kush141087 or check the Raw DATA

[Kushal_Chawda]

Yes, you have set the values by 2014 & 2015, but it will work only in expression. Because expression evaluates first.