Collection: Sort by attribute value
When creating a collection, would like to sort the collection by a specific attribute value (what is shown in the collection). For example, a collection of tanks showing percent full. Would like to be able to order the collection by percent full, to show the most full tanks at the top of the collection. This functionality should also be added to the Asset Comparison Table.
This idea would provide tremendous benefit to those who are using collections to visualize large amounts of trends. Example : if you were reviewing Heater Temperatures/Pressures, you want the user to review all 50 of these trends, but the highest temperature is the first item you want to be shown first so that it's always getting the most visibility.
This solves many problems when we prepare a dashboard for a fleet.
We need to add the attributes by which we could do the sorting, just like how we filter for specific elements by aAsset Type --- > Asset attributes
Louis-Philippe Page-Morin commented
This is essential to be able to undertand your TOP 10, TOP 50, TOP X assets or worst assets, based on an attribute value, without having to look at the full collection to search for those assets. Basically, this would be to have a similar functionality than the Asset Comparison Table symbol, for which you can order the rows by the values of the various columns you decide to display.
Yes, sorting by attribute value and also by the full path string would be quite useful.
our use case is to show the health values of assets. The desire is to sort from the 'sickest' asset (highest value) to the least, so you don't have to hunt through what could ultimately be several hundred pumps and motors. Thanks you soooo much for considering this in the next release ;-)
We really need this. Currently we are dismantling collections more and more to have control over the sorting. And then while the Collections are one of the best features in PI Vision!
This definitely needs to be an option in future releases. Currently the random sort makes the awesome power of the collections very difficult to view when setting up a display for 28 different sites. In our case we would like to sort on a Site attribute so that we could view the data for our plants in alphabetical order. Or an option to sort on the parent element would be nice too.
In response to Vincent Kaufmann, "I think there is a bug in how PISquare i..."
Ahh ok that makes sense then
I'm surprised how many down votes this has received? I'm wondering if its possible to write this functionality ourselves easily? We are using collections for nice lists (the asset comparison table is good, but still a bit limited) The problem is, we'd like the sorting to match the hierarchy, lets say Element1 has child elemehts A B and C, and Element 2 also has A B and C but may also have a D E and F aswell. The collection is grouping all the A's, grouping all the B's, but we want to see Element1 > A, B, C then Element2 A,B ...... (contrived example but you get the idea!)
Vincent Kaufmann commented
In response to Keilan Knight, "I'm surprised how many down votes this h..."
I think there is a bug in how PISquare is interpreting votes and what is actually on the feedback site
This would be a extremely useful idea when required to present data in a league table type presentation.
I really like the new symbol collection in pi vision.
I would like to have the possibility to order the assets in the collection not by name but by any attribute of the asset.
That could be quite useful for sorting asset f.e. by sales or amount produced.