- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2022 12:47 AM
Does anyone know the best way to populate the top 10 customers?
Solved! Go to Solution.
- Labels:
-
Dashboards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2022 10:07 AM
Ty you! I looked right past it. LOL 😂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
