Forum Discussion
Solved
Return Top N 3 rows for a Table Visualization
Hi, I have a table visualization which is coming from a table 'xx'. The last column is a count of 'Tickets' from the table 'xx' where 'Count(District)' is applied. Table 'xx' contains 'organization'...
The Top N works based on another column, so you should filter for example Name, based on Count. There you are filtering staight Count. Apply the filter to either Organization or Name and it should work.
Hi there!
To apply the Top N filter you should do it on Name for example and based on Count of Tickets value. So you are basically saying, "return the top 3 names by Count of Tickets"
It should look something like this:
Let me know if that helps!
From my view, there is no Top N
The Top N works based on another column, so you should filter for example Name, based on Count. There you are filtering staight Count. Apply the filter to either Organization or Name and it should work.
Thank you! It works. I see, Top N only be applicable for 1 field