I am trying to use Airtable to track monthly downtime for each IT service in an organization. I have a table for entering individual service interruptions, which has a multi select linked field to another table listing all our services.
The goal is to be able to use a rollup field to show the total downtime for each service. I think I have that bit working. The problem is I need to be able to show the downtime per service by month, and when I group by the month tab it treats “Oct, Sept” as one month, etc.
Is there a way to group or filter that will “break out” the results in the multi select field?