Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
In Chart Properties -> Dimensions Tab, select Brackets dimension and check the flag "Show All Values"
In Chart Properties -> Dimensions Tab, select Brackets dimension and check the flag "Show All Values"