Hello, I want to know how to display the item that comes up most often in a list of data base. Example : employee 1 does more tasks than employee 2, so I want to display the most active
How are you establishing which Employee is the most active?
Hi there, @rayanerachid91212… Adam’s question is the right one, of course, but based on what you described, here is an example where I have a Task data type that has a completed by field that is linked to the User data type. With that setup in place, a repeating group that is configured as follows would show a list of users in order (assuming your sort is descending) by the users who completed the most tasks.
Hope this helps.
Best…
Mike
Hello ! Each invoice is assigned to an employee who made it, I want to display in a text the employee who made the most invoices.
Do a search for Invoice grouped by assigned User. Aggregate By count and sort by count descending “yes”. This is one way. That is possible if the User is also saved on the Invoice data type.
Yup, what William said… or what I said in my initial reply because my example literally shows that exact setup with different names for things. Did you try what I showed?
The example I showed is the data source for a repeating group, not a text element. If you want to show the top user in a text element, try this, and make sure the sort is in descending order.
It works thanks ! In fact I had put “each item user” and not “first item user”