Single Sheet with Different time period aggregation

Question & Answer
, ,
1

hi,

i have a data set based on daily activity. I am trying to create a sheet where I can have a control that shows the data aggregated over a week or month based on a given timeframe

basically i want to give a user the ability to look at year’s worth of data aggregated weekly or monthly

2

Yes you should be able to do this.

This article has a lot more, but will answer you question.