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 shared this idea · May 8, 2014
Comments
1 comment
Hi Nathan,
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!
http://help.trackvia.com/knowledgebase/articles/356703-child-functions
Regards,
Derrick
Please sign in to leave a comment.