Is there a way to show top 3 most frequently (used) items by the same user?

[rezmeplx]

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!

[nathanaelb]

@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?

[nathanaelb]

@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.

[rezmeplx]

Hi, Thank you for replies.
I kind of figured out how to list items with the count

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!

[rezmeplx]

@glide How do I eliminate duplicate items in the collection? So that only unique items appear

[Jeff_Hager]

This should help to eliminate duplicates. This is an excerpt from a different post.

@Jeff_Hager

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.

[rezmeplx]

Thank you !