Restrict dimension value

[sergio0592]

Hi all,

I have the following issue : in a bar chart i want display all value for my dimension Age, even if count is null. So, it's ok (see the snapshot below).

But i'd like to restrict only Age>=27. When i put as dimension =if(AGE>=27,AGE) it remove null value like 51, 53,54,55 even if i uncheck "suppress null value".

Is there a way to fix it?

Thanks

[sunny_talwar]

Would you be able to share a sample or image to show the issue?

[jaumecf23]

You can try to not modify the dimension and force it in the Expression. Something like this:

Expression : sum({<AGE={">=27"}>}Amount)