Calculate % amounts of several colums in a table (SUM)

[NLR_SPA_Yukon]

We have a grid view generated, which shows us the percentage per column (it is a room occupancy rate).

We would like to get a total occupancy rate per time period calculated. But we have no idea, how to approach it.

Does anyone has an idea how to do it?

[dilipborad]

Hello @NLR_SPA_Yukon 

Just create different views and filter it by different date range.

Check these help articles or some of the older videos.

Getting started with Airtable views | Airtable Support

Filter Records Using Conditions | Airtable Support

TUTORIAL: Views, Filter, Sort, and Group in Airtable - YouTube