Setting up fields for a Shot Summary Page

Hi, I’m working to set up a shot summary page so the prod team can easily glance and check whether the project is staying within assumptions

I’m running into some difficulty creating fields that will display the below info:

  • % of crowd shots (+5 characters in a shot)
  • Avg Character count per episode
  • % of Shot that has FX

For character counts, I managed to create a query field that lists out the number of characters that was tagged per shot, but discovered I can’t really that data into another field to get an avg or highlight a high character shot.

Love to hear if yall have any tips or suggestions to best gather the above data.