Hello team! I am trying to calculate the average weekly attendance in airtable. I downloaded the data from airtable and was able to calculate it in excel using an "averageif" function but I am not sure how I can implement it in airtable. The last col...
Hi Kuovone,So I have done that but I am unsure how to make it so the "where" statement encompasses whenever the unique identifier is the same. For instance the fifth week of 2023 will have the unique week identifier "20235" for each day the attractio...
Hi Adam! Thanks for the help, this seems to be on track for what I am looking for! Is there a way to automate the dates that populate as linked records based on the unique week identifier? The entire data set has almost two years worth of data so it ...
