27 Apr 2020 10:22 AM
I have a group filter that I would like to return the Top 10 rows. Is there a way to apply a Top n rows filter?
28 Apr 2020 12:53 PM
Ideally, you can do it all via your SQL Data Layer using a TOP/LIMIT clause. If not, you can do it in Logi with a few extra elements. After your group by add a Rank Column (a child of the data layer not the group by) and then a Compare Filter after the Rank Column. You might want to set your rank to order in reverse to get the biggest number. On your Compare Filter just set up your values and you should be good to go.
29 Apr 2020 09:15 AM
thank you that worked, I needed to allow for Logi to group the data rather than using Top clause in SQL since I am adding Analysis filters to allow for user to filter on non-aggreagated fields to show Top 10 for the applied filters