I have two tables (on different pages)
The first auto-creates a row each day, and looks like:
Table_1
| Name | Created date | integer A |
---------------------------------------
| 1/1/2001| 1/1/2001 | 5 | The second table is also autogenerated, and looks similar to the following (although with two autogenerated rows per day
Table_2
| Name | Created date | integer B |
---------------------------------------
| type_1 | 1/1/2001 | 7 |
-------------------------------------
| type_2 | 1/1/2001 | 8 |I want the a way to get the following result
Table_1
| Name | Created date | integer A | value C |
-----------------------------------------------
| 1/1/2001| 1/1/2001 | 5 | (7+8)/2 |A new row on Table_1 with the average of the values of B with the same creation time as the row on Table_2
Any ideas how to do so? I didn't manage using rollups and etc (and tried bing chat as well, just to make sure)
(In reality the first table is a habit tracker, and the second table is exercise with weights, reps and completion rate for each)
