The sheet seems useful as a way to communicate Anne's requirements but can't be used "as is" to develop the app's MVP. To filter the required data (e.g. pick a specific indicator) we need to first restructure it (e.g. tidyr::pivot_longer()). That effort seems greater than producing toy data from our toy data and code, which will also ensure the app truly integrates with the rest of the system.
Spreadsheet
Snapshot on 2024-05-22
The sheet seems useful as a way to communicate Anne's requirements but can't be used "as is" to develop the app's MVP. To filter the required data (e.g. pick a specific indicator) we need to first restructure it (e.g.
tidyr::pivot_longer()). That effort seems greater than producing toy data from our toy data and code, which will also ensure the app truly integrates with the rest of the system.