How do I...?

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.

1 vote
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Nathan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Nathan Waterman commented  ·   ·  Flag as inappropriate

    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.

  • Derrick Kotlus commented  ·   ·  Flag as inappropriate

    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

Feedback and Knowledge Base