I’m building a page that’ll contain a table of aggregate data by “location”. I.e. total number of assets and the total value of said assets per location etc. A user can click on a table row to get the assets for said location as a list. I’m of course planning on modeling out my Assets but I wanted to know how the community generally handles pulling just aggregate data on said model.
Through Metadata on the Asset model? Maybe a separate model just for this data? Perhaps a model for my Locations that contains the aggregate data?
Pretty sure this is a standard thing to do and wanted some feedback from those who’ve done it before.