Forum Discussion
Top N does not work correctly
Hi,
I am facing some problem with Top N filter. I am trying to compose a visual showing top 7 employee by sum of CzasGodziny. But the result returns much more rows... See pics below. There are no ties between 7th and 8th row, so I have no idea what's happening. If I put top 10 or top 15 filter, the result still does not return correct number of rows.
Could anyone tell me what would be the reason? It behaves similarly also for other coulmns, nevermind if they are of integer or real data type.
Thanks in advance for any help!
Hi krzysztofpiotro,
The result is expected. It has duplicates. Maybe the result on the right is what you want. Any other requests, please feel free to input here.
Best Regards,
Dale
5 Replies
Hi krzysztofpiotro,
Can you share the file? Please mask or delete the sensitive parts first.
1. It seems the Visual Level filter. Did you apply it in the left table?
2. Please also upgrade to the latest version of Desktop.
Best Regards,
Dale
Hi,
Thanks for reply. I have sent you the file - see private message.
Regarding questions:
1. Yes, this is Visual Level Filter applied to the depicted table and it does not work correctly.
2. Unfortunately, upgrade to the newest version did not help.
Hi krzysztofpiotro,
The result is expected. It has duplicates. Maybe the result on the right is what you want. Any other requests, please feel free to input here.
Best Regards,
Dale
