Forum Discussion

krzysztofpiotro's avatar
krzysztofpiotro
Frequent Visitor
8 years ago
Solved

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 ti...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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.

    Top_N_does_not_work_correctly

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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

  • krzysztofpiotro's avatar
    krzysztofpiotro
    Frequent Visitor
    8 years ago

    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.

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      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.

      Top_N_does_not_work_correctly

       

       

      Best Regards,

      Dale

      • krzysztofpiotro's avatar
        krzysztofpiotro
        Frequent Visitor
        8 years ago

        Yes! This is the result I wanted to reach. Thank you very much :)