Budget: 1500 UAH Deadline: 4 days
Maxime, good afternoon. The main trap in such tables is not the graphs, but the dates. If the flights are listed as a raw list, breaking them down by weeks and seasons cannot be done with simple formulas - a separate layer for normalizing dates (week number, month, season) and pivot tables that automatically pick up new rows are needed. Then the graphs of prices and the number of uploads are updated without manual recalculations.
I will create a sheet for data entry, summarized by periods, and a separate dashboard with dynamic graphs. I constantly work with Google Sheets and Apps Script for business analytics. One clarification - will you be entering the data manually or is there an export from some system? This affects whether to add import.
Approximately 1500 UAH, 4 days.