Forum Discussion
Filter Order issue with TOP N usage
Apologies for the delay. I have reworked the visuals so this is no longer a problem, but have never actually solved why the visual had gone blank. Thank you for your attempts to help me though it is hugely appreciated!
When I take the sample data, I am getting expected results.
I have it set to bottom 2 (without the filter on 0 just yet to ensure it is doing what we want) and I see Eve and Penny
When I add in the filter for is not 0, it changes to James and Penny, which is expected:
Can you ensure that there are rows where the role is Production and adjusted committment is not 0?
There are most definitely rows. The data set invovles hundreds of people, most of them are with a normal commitment. I can't give the data as it is private, nor can I generate an accurate false version of the data (time constraint). I know it's not the most helpful, my filter theory is just a theory but it's the only thing that makes sense.