Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

TOPN filter output not ideal

I'm using a TOPN filter on a visual, and it is showing more than the number prescribed.  This is because they all have an identical value.  This visual is meant to be a snapshot of the current state of this part of the business, so the extra lines are not required.  Is there a way to "hard limit" it to TOPN, just choosing the necessary number for the visual?

 

 

Thanks

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    add a very small random number to your values.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous,

     

    Maybe it is not supported to sort duplicate values using TOP N, you can add index column to get your expected output.

     

    Best Regards,

    Link

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I like your solution, except I'm working with measures.  Your solution definitely has a place with other applications and I will try to remember it.  Thanks for your reply!