How to sort the data in the result page with the most outstanding number of field like ' top sales person'?

[Cherry]

Hi, guys! I need some help.

I have a table with fields: customer ID (unique), sales person ID (text 255), timestamp, etc...

This is the case, in every customer who fill up the submission form, they must include the Sales Person ID who assisted them. So, what I want in my result data page is I want to sort out the 'Most Outstanding Sales Person. How can I do that?

[cheonsa]

Hi @Cherry,

Based on what I understand, in your Reports Page, you will have a column for Sales Person. Then, you would like to sort the report based on the most outstanding sales person. 

First, you need to have a calculated field in your reports. You can have an SQL statement to count how many instances that this sales person is being selected by the customer. 

For example:

SELECT COUNT(Sales_Person_ID) FROM TABLE WHERE Sales_Person_ID=target.[@field:Sales_Person_ID]

Change the field name and the Table Name. 

Lastly, sort the report using this calculated field. See screenshot below for the sample.

 

Hope this helps.

[Cherry]

Thank you. I will try. Update you soon if working..Thank you so much

[Cherry]

Thank you so much, it works.

[cheonsa]

On 5/24/2021 at 3:59 AM, Cherry said:

Thank you so much, it works.

Great!  For more reference, see these articles available in Caspio site:

https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

 

 

[Queso]

Hi, 

You can also create a DataPage, which is similar to a counter card that displays the most outstanding value and can be placed anywhere on your webpage. You can watch this Caspio video guide to learn how to make it: