Automatic weekly and monthly reports from a daily data

Hello to everybody!

Here is an example of daily reports with data.
I want to create tables “weekly report” and “monthly report” from that main table.

In weekly report there should be list of “offers”, their summary spend, leads, profit and average ROI.
Same in month report.
But don’t have any idea how to make it. Please help!

Dear @Rat_Race,

Would you mind to update the sharing settings of your doc as in the screenshot below:

Done, check it please

Dear @Rat_Race,

Hopeful this is what you are looking for:

Not exactly, but suppose with such approach i will be able to do that in a right way. Thanks, Jean!

Dear @Rat_Race,

If you had something else in mind :thinking:, I would be glad to try to support you.

@Rat_Race , can you please tell me how you got from that to monthly, etc. reports? I’d like to build tables with montlhy averages of a daily data, and then yearly averages from that as well. I couldn’t get from Jean Pierre’s doc to that.