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.
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. Or post something like this that allows you to see the most successful employee. What is the best solution?
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?
I did exactly what you told me to do except that in the text it shows all the users and not just one user who made the most sales.
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.
1 Like
It works thanks ! In fact I had put “each item user” and not “first item user”
1 Like
This topic was automatically closed after 70 days. New replies are no longer allowed.