Forum Discussion
LYorkToenniges
Helper III
Helper IIIFilter Order issue with TOP N usage
I will do my best to share sample data but this is hard to explain. I am attempting to have a Bottom 5 performers visual (my top 5 works fine BTW) and it seems the filter to prevent people with "Adj...
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!
audreygerred
Super User
Super UserWhen 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?