topic Re: Top 10 customers in Dashboards & Analytics Discussions

Top 10 customers

Jkovachi — Thu, 24 Mar 2022 07:47:33 GMT

Does anyone know the best way to populate the top 10 customers?

Re: Top 10 customers

RADSr — Thu, 24 Mar 2022 15:16:25 GMT

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"

Re: Top 10 customers

JoeM — Thu, 24 Mar 2022 15:33:39 GMT

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.

Re: Top 10 customers

Jkovachi — Thu, 24 Mar 2022 17:07:24 GMT

Ty you! I looked right past it. LOL 😂

Re: Top 10 customers

RichC — Thu, 31 Mar 2022 15:13:32 GMT

Joe, Thanks for sharing.

This is method I use for filtering the Top n.

Re: Top 10 customers

RichC — Thu, 31 Mar 2022 15:14:55 GMT

[TEST BUMP]

Re: Top 10 customers

dweaver — Thu, 15 May 2025 18:56:54 GMT

What is there is groups? I am displaying a retail pack size and the customer in the rows of a pivot table. I want to see the top 10 customers by retail pack size. How would I do that?