Forum Discussion
Create a calculated table, with annualized data, based on another table with monthly data.
Hello community,
I'm wanting to generate a new table, with annualized (averaged) data, based on the existing data in another table that shows me data month by month.
Example:
Table1 with monthly data.
| Date | Item | Value |
| 01/01/2020 | Number 1 | 67 |
| 01/02/2020 | Number 1 | 76 |
| And so on until December 2020... | ||
| 01/01/2021 | Number 1 | 35 |
| 01/02/2021 | Number 1 | 45 |
| And so on until December 2021... | ||
| 01/01/2022 | Number 1 | 86 |
| 01/02/2022 | Number 1 | 37 |
| It would be fed month by month... |
With that table I would like to create another one that shows me the average of each item per year and that the calculation is generated automatically as the months per year progress.
Table2, calculated, should look like this:
| Date | Item | Annual Average Value |
| 01/01/2020 | Number 1 | 23 |
| 01/01/2021 | Number 1 | 14 |
| 01/01/2022 | Issue 1 | 3 |
Is there a way to do it? I was looking at the topic of calculated tables but I didn't find a way that would allow me to do what I need.
Thank you in advance for your help!
2 Replies
That soundas doable. Please provide usable sample data and indicate expected outcome.
Hi Syndicate_Admin ,
You can use the default average measure via the "v" icon as the below picture.
Or please share example data and expect result.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
