03-24-2022 12:47 AM
Does anyone know the best way to populate the top 10 customers?
Solved! Go to Solution.
03-24-2022 08:16 AM
That is a good question since ( I just learned trying to answer it ) "rank()" is not a supported function in an aggregate filter.
The best answer I could find is from this Incorta document: https://docs.incorta.com/5.1/guides-analyze/ ( just CTRL-F in your browser and search for "top 10"
03-24-2022 08:32 AM - edited 03-24-2022 08:33 AM
If you have an insight already set up with all of your top customers sorted into descending order, you can go to the 'cog' in the top right of the insight settings and set the 'max rows limit' to 10.
03-24-2022 10:07 AM
Ty you! I looked right past it. LOL 😂
03-31-2022 07:56 AM - edited 03-31-2022 08:13 AM
Joe, Thanks for sharing.
This is method I use for filtering the Top n.