Tracking Email Open Rates based on tags


I wanted to enter emails into an airtable. Each email would be its own record and their would be three fields - open rate (percentage), click rate (percentage), and ‘tags’ (multi-choice).

I want to be able to average the click rate/open rates based on the different tags I give the emails. So say I have a tag called ‘topic 1’. I want airtable to create an average of all the open rates or click rates for all the emails with the tag ‘topic 1’ in the multi-choice tag field.