# Is there a way to show top 3 most frequently (used) items by the same user? **URL:** \ **Category:** Ask for Help\ **Created:** [February 9, 2023, 3:58pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703 "2023-02-09T15:58:28Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 3:58pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/1 "2023-02-09T15:58:28Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d53e505aa6c0734eb00f0cca6d93b15651d03720.png) Actually this is sort of a stock portfolio I am trying to build. I want to show the top 3 most frequently traded “symbol” by the current user. Is it possible with glide table? tried some searches but failed to find my case. Thank you! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 9, 2023, 4:35pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/3 "2023-02-09T16:35:24Z")
@glide A user adds items to a collection. These items might be added multiple times to the collection. How might the user determine which 3 items were added the most? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 9, 2023, 4:38pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/5 "2023-02-09T16:38:48Z")
@glide As far as I know, there is no such thing as a count action. Please explain to me how to determine the number of times an item appears in a collection. ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 5:09pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/7 "2023-02-09T17:09:35Z")
Hi, Thank you for replies. I kind of figured out how to list items with the count ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9320a03a7c212f2004d8eab82211b33e9a1be110.png) but here’s the last problem… How do I eliminate duplicate items? so that only unique items appear in the list? in this case, it should be only S&P 500 and Nasdaq and then followed by Dow, only one each. Thank you! ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 5:21pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/8 "2023-02-09T17:21:53Z")
@glide How do I eliminate duplicate items in the collection? So that only unique items appear ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 9, 2023, 7:29pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/9 "2023-02-09T19:29:21Z")
This should help to eliminate duplicates. This is an excerpt from a different post. > [@Filter out duplicate items](https://community.glideapps.com/t/filter-out-duplicate-items/48988/2): > > Ultimately I would probably set things up differently. But to stick with your current setup, what you can do is create a template column that joins Business and Category together. Using that template, create a single relation back to itself. Then create a Lookup column that returns the Row ID from the relation. Finally create an IF column that checks if the Row ID matches the Lookup Row ID. If it’s a match, then return true, else false. Or you could probably just have the IF column return the Category name. This will give you a boolean value of true (or Category name) only in the rows that have that Business/Category combination the first time it appears in the data. This will give you an additional value that you can use in la filter. ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 8:24pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/10 "2023-02-09T20:24:25Z")
Thank you ! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 10, 2023, 8:25pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/11 "2023-02-10T20:25:11Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.