07-03-2015 10:37 AM
I'm experimenting a problem in using filtering and ranking features in a bar-chart.
I have a category (CAT1) with more than 5000 occurrences and 2 measures (M1 and M2).
I need to show in a bar-chart the worst 10 items (not missing) according M1, but for which M2 >=5.
The problem is that with these filters and ranking I always have an empty chart.
I do some attemps and it seems as ranking is applied before filtering and not aftes (as I need!!!)
Can anyone help me?
Thanks a lot in advance!!!
07-06-2015 10:31 AM
Thank you for your answer.
I've already tried an IF/ELSE statement with a new measure M1_1 with Missing in ELSE statement, but it doesn't work.
Now I try setting an out-of-scale value (in my much more big than max value, because I need to show the most little values) for M1_1 and in this case it works!!!
My be "Missing" value is not suit for classifications...
Thank you very much indeed!!!
07-06-2015 11:09 AM
As I understand it, the problem is that "Bottom" rankings in VA include missing values as the least values, so your calculated item,
IF M2 => 5
Gives all missing values as its "Bottom 10" rank.
Is that what you are seeing?
If so, you might try adding a filter on the calculated measure and deselecting the "Include missing values" checkbox.
Or as a filter expression,
I believe that should give you the desired result.