We have a file that contains our daily metrics across the company that gets updated every morning.
We are interested in setting up some trend charts at the top of the sheet where we can select the metric in a dropdown and update the chart to show the last 7 days of data (or potentially other date ranges). I've created a similar file for another project, but the data in that was created by entries on a form so it was set up like a typical data set.
In this case, the sheet is currently set up like this. Each day we update the next day. We have about 150 metrics in total and (obviously) the data will continue on the right for every day.
Any advice on how to set this up to achieve this? Let me know if this isn't enough information.
We are interested in setting up some trend charts at the top of the sheet where we can select the metric in a dropdown and update the chart to show the last 7 days of data (or potentially other date ranges). I've created a similar file for another project, but the data in that was created by entries on a form so it was set up like a typical data set.
In this case, the sheet is currently set up like this. Each day we update the next day. We have about 150 metrics in total and (obviously) the data will continue on the right for every day.
| KPI | Sun, 01/28/2024 | Mon, 01/29/2024 | Tue, 01/30/2024 | Wed, 01/31/2024 | Thu, 02/01/2024 | Fri, 02/02/2024 | Sat, 02/03/2024 | Sun, 02/04/2024 |
| Metric A | 398,310 | 398,508 | 398,663 | 398,886 | 398,997 | 399,145 | 399,145 | 399,145 |
| Metric B | 0 | 198 | 155 | 223 | 111 | 148 | 0 | 0 |
| Metric C | 514 | 515 | 516 | 517 | 518 | 519 | 520 | 521 |
Any advice on how to set this up to achieve this? Let me know if this isn't enough information.
