New task was created
Aggregate data by time period for data visualisation
Created on Thursday 1 September 2022, 14:16Back to task list
ProjectMetabolism of Cities Data Hub
TagsGeneral data hub improvements
SubscribersCarolin BellstedtPaul Hoekmanjoe
Objective: We usually need data for a certain year. However, often times there is data provided in other time periods, daily, weekly, monthly, quartlery etc.
It would be great to aggregate data by time period. The user should be able to do so in the data viz configuration (chart editor, example).
Audience: The user could be someone who needs a viz for a paper, some study or a blog post and would like to save / print it or embed it.
How it works: Let's use the data example of the Natural gas production in Norway, 2017-2021, monthly to see how this should work:
- the user goes to the chart editor of the file (see screenshot)
- the aggregation function could live with the "other setting" options, see red arrow
- there should be an AGGREGRATE BY: field that can be toggled on. It could have a dropdown list of options that it can be aggregated to, but that is optional for later. For now, let's make BY YEAR work.
- the system needs to check if: (1) data are in the same unit so that they can be aggregated, (if they aren't in the same unit, there should be a warning that those need to be converted first, unless the system can do it (?), see unit task). (2) Further it needs to be checked what interval the data is in, to add it correctly. ( I don't know if the system can check this, or the user would need to select the interval.) --> When monthly, all 12 months need to be added up, and if weekly, all 52 weeks need to be added up etc. In this example, instead of having data for every month, there will be 5 years shown (2017, 2018, 2019, 2020, 2021).
- the new tailored graphic should be able to be saved separately, see task which allows that
- when the main chart is saved with the aggregated data, there could be a small warning on the main page "This data is aggregated by year. To see detailed data, you can change this in the chart editor."