I want to display a list of users in an order from 1st - 10th based on performance. for example; I’m having users refer other users to my app. So I want to have a public page that dynamically displays the user with the most referrals in 1st place, user with second most referrals in 2nd place, etc. Any advice would be greatly appreciated.
Hi @robertoquinonez33, how i’d approach this is:
-
I’d create a “Performance” field (field type number) to the User data type. This needs to be a number so you can do math functions with it. Also set the default value to 0.
-
When a referral is done, make a change to the referred user by adding +1 to the performance of that user.
-
Then you can set your repeating group to Type Users, do a Search for Users and then in that search do a Sort by Performance and make Descending = yes.
Hope this helps.
1 Like
Nice. Thanks for taking the time to respond…
I have a similar requirement but with a slight variation.
I am building a dashboard for a CRM where along with the other lead related metrics, I want to display the username for the user who has created the most lead entries. I also want to display the username of the person who had converted the most leads. The dashboard will be generated for a period selected by the user.
My lead table for eg is:
Lead Name
Contact
Address
Location
Status
Created By
Created Date
Lead Name Contact Address Location Status Created By Created Date
James XXXX Enquiry Louis 11/4/2018
Sarah YYYY Converted Louis 11/14/2018
Dave ZZZZ Enquiry Chris 12/8/2018
So if the user selects a period between 11/1/2018 to 12/10/2018 (the period is not pre-defined but dynamically selectable) , then on the dashboard
For Most Leads Started : I want to be able to show Louis
For Most leads Won : I want to show Louis
Looking for help on this problem.
This topic was automatically closed after 70 days. New replies are no longer allowed.