Using a Ranked layout with your table requires two settings to make it work:
- Sort Field & Order
- Ranked Layout
Both of these can be specified in either the table or the menu item you're using to display the table. If you specify the Sort Field in the table itself then all you have to do in the menu is select Table Layout (Ranked) for the Menu Type (as shown above).
If you do specify a Sort Field and Sort Field Order in the menu it will replace the values set in the table. This can be handy if you have several columns that you want to display the table ranked against (e.g. player rating, season points or number of fouls).
The Sort Field Order is used to determine the order of ranking. If you want the row with the highest value to get a rank of 1 you would set the Sort Field Order to Descending. If you want the row with the lowest value to get a rank of 1 you would set the Sort Field Order to Ascending. For the example NBA Rankings table on the demo web site, we've used the following settings in the Menu Item options:
It is important to remember that the RANK value must be calculated against all of the records in your table, this means your database server is doing all of the work on each table request. The larger the table the more work and RAM that will be required by your server. For these reasons, on shared server hosting ranked table views are not recommended for large tables, instead, it is recommended that a pre-calculated rank column be used rather than EasyTable Pro!'s dynamic rank calculation. To determine if your table is too large for your server, you can perform a simple calculation of # of Rows x Average Length of Each Row in Characters ÷ 1,048,5768 to calculate the M required by your server vs the memory available.