How do I limit the number of records that show up by rank?
I would like to have a top 10 list of items checked out in a asset tracking app. Right now I am trying to use the count field as a basis for this filter, but because the list constantly changes, I can't filter by a set number. it needs to be highest to lowest and only show 10 records. Anyway to do this.
Nathan Waterman commented
Can I apply this to a summary graph such that I only show Top 5 or Top 10 etc? I've setup the calculated text field and I can remove the 0 count items but can't figure out how to sort on a graph.
Got it, didn't see the sort function write away...Thanks!
Derrick Kotlus commented
You should be able to accomplish this through the use of a calculated text field that utilizes the count() function. Below is a great article from out knowledge base discussing this function. After you have set up this field that counts all of the check outs per asset, you can simply sort this column in your grid view in descending order(largest to smallest). Lastly, if you limit your view to 10 assets per page, you will only see the top ten assets that have been checked out the most. This list will continue to change as you check assets out as well. Hope this helps!