class/brackets show all

[#1]

Hi,

I'm trying to categorize values in classes. so far no problem.
instead of class I tried several if statements.

if(amount <20, '0-20', if(amount <41, '21-40',if(amount <61,'41-60', if(amount < 81,'81-100')))) AS Brackets

How can I show always all classes/brackets, also if they don't exist for the current selection?

Thanks for your help.

Aloah

[Miguel_Angel_Baeyens]

You should add an additional if statement controlling isnull(amount), i.e.:

if(not isnull(amount<20),(condition for not null amount<20),(condition for null amount<20))

Regards.

[#3]

In Chart Properties -> Dimensions Tab, select Brackets dimension and check the flag "Show All Values"

[#4]

In Chart Properties -> Dimensions Tab, select Brackets dimension and check the flag "Show All Values"