How to Sort Assets by Appearing on Most Shots?

I have several assets on Shotgrid that appear on multiple shots.
However, I need to prioritize production on assets that appear on most shots.

Is there a way to filter, group or organize my Assets page so that the assets that appear on most shots are on top of the page?

You could create a field on the assets entity that stores the count of the number of shots, and then sort by that. You might need to write it as a scriptthat trriggers, you wouldn’t want a summary field as the summary field won’t support sorting.

1 Like

I think a Query Field on the Asset entity would do this: