Forum Discussion
Antoinette123
Helper I
Helper ISum of every 2 weeks
I have a column with id, it has repeated items and columns with values. Data are like week 1, week 1, week 2, week 2, etc. I need to create a table where for week 3 I have an average value between 2 ...
Antoinette123Helper I
Helper I| Table 1 | |||||
| id | value 1 | value 2 | I need => | id | value |
| car; week 0 | 1 | 6 | car; week 3 | average(3;4;5;2;8;3;2;8) | |
| car; week 1 | 3 | 4 | car; week 4 | average(8;3;2;8;1;1;9;9) | |
| car; week 1 | 5 | 2 | byke; week 3 | average(7;6;5;2;8;3;1;4) | |
| car; week 2 | 8 | 3 | byke; week 4 | average(8;3;1;4;1;1;9;9) | |
| car; week 2 | 2 | 8 | |||
| car; week 3 | 1 | 1 | |||
| car; week 3 | 9 | 9 | |||
| car; week 4 | 4 | 3 | |||
| car; week 4 | 2 | 2 | |||
| byke; week 0 | 0 | 4 | |||
| byke; week 1 | 7 | 6 | |||
| byke; week 1 | 5 | 2 | |||
| byke; week 2 | 8 | 3 | |||
| byke; week 2 | 1 | 4 | |||
| byke; week 3 | 1 | 1 | |||
| byke; week 3 | 9 | 9 | |||
| byke; week 4 | 4 | 3 | |||
| byke; week 4 | 2 | 2 |
Hi Antoinette123 ,
Did ronrsnfld's answer help? If so please help mark it as a solution, this time increase the weight when searching for similar questions, thus helping more people, thanks~
Best Regards,
Gao
Community Support Team