Forum Discussion
New Row With Calculated Values
Hi, So, I'm trying to build a table with the company name, date, the number of accidents (and other variables, but let's simplify) and a calculated formula between the 2 dates I select (for which...
Anonymous , Not very clear. Can you share sample data and sample output in a table format?
Sample data:
| Company | Date | N accidents | Days off |
| A | 01/01/2017 | 2 | 15 |
| A | 01/02/2017 | 4 | 27 |
| A | 01/03/2017 | 4 | 27 |
| A | 01/04/2017 | 4 | 27 |
| A | 01/05/2017 | 4 | 27 |
| A | 01/06/2017 | 4 | 27 |
| A | 01/07/2017 | 4 | 27 |
| A | 01/08/2017 | 4 | 27 |
| A | 01/09/2017 | 4 | 27 |
| A | 01/10/2017 | 4 | 27 |
| A | 01/11/2017 | 4 | 27 |
| A | 01/12/2017 | 4 | 27 |
| A | 01/01/2018 | 0 | 0 |
| A | 01/02/2018 | 0 | 0 |
| A | 01/03/2018 | 0 | 0 |
| A | 01/04/2018 | 0 | 0 |
| A | 01/05/2018 | 0 | 0 |
| A | 01/06/2018 | 0 | 0 |
| A | 01/07/2018 | 0 | 0 |
| A | 01/08/2018 | 2 | 17 |
| A | 01/09/2018 | 2 | 17 |
| A | 01/10/2018 | 2 | 17 |
| A | 01/11/2018 | 2 | 17 |
| A | 01/12/2018 | 2 | 17 |
| A | 01/01/2019 | 0 | 0 |
| A | 01/02/2019 | 0 | 0 |
| A | 01/03/2019 | 0 | 0 |
| A | 01/04/2019 | 0 | 0 |
| A | 01/05/2019 | 0 | 0 |
| A | 01/06/2019 | 0 | 0 |
| A | 01/07/2019 | 1 | 0 |
| A | 01/08/2019 | 1 | 0 |
| A | 01/09/2019 | 1 | 0 |
| A | 01/10/2019 | 2 | 0 |
| A | 01/11/2019 | 3 | 0 |
| A | 01/12/2019 | 4 | 0 |
| A | 01/01/2020 | 0 | 0 |
| A | 01/02/2020 | 1 | 0 |
| A | 01/03/2020 | 2 | 0 |
| A | 01/04/2020 | 2 | 0 |
| A | 01/05/2020 | 2 | 0 |
| A | 01/06/2020 | 2 | 0 |
| A | 01/07/2020 | 3 | 0 |
| B | 01/01/2017 | 0 | 0 |
| B | 01/02/2017 | 0 | 0 |
| B | 01/03/2017 | 0 | 0 |
| B | 01/04/2017 | 0 | 0 |
| B | 01/05/2017 | 0 | 0 |
| B | 01/06/2017 | 0 | 0 |
| B | 01/07/2017 | 1 | 5 |
| B | 01/08/2017 | 1 | 5 |
| B | 01/09/2017 | 1 | 5 |
| B | 01/10/2017 | 1 | 5 |
| B | 01/11/2017 | 1 | 5 |
| B | 01/12/2017 | 1 | 5 |
| B | 01/01/2018 | 0 | 0 |
| B | 01/02/2018 | 0 | 0 |
| B | 01/03/2018 | 0 | 0 |
| B | 01/04/2018 | 0 | 0 |
| B | 01/05/2018 | 0 | 0 |
| B | 01/06/2018 | 0 | 0 |
| B | 01/07/2018 | 0 | 0 |
| B | 01/08/2018 | 0 | 0 |
| B | 01/09/2018 | 0 | 0 |
| B | 01/10/2018 | 0 | 0 |
| B | 01/11/2018 | 0 | 0 |
| B | 01/12/2018 | 0 | 0 |
| B | 01/01/2019 | 0 | 0 |
| B | 01/02/2019 | 0 | 0 |
| B | 01/03/2019 | 0 | 0 |
| B | 01/04/2019 | 0 | 0 |
| B | 01/05/2019 | 0 | 0 |
| B | 01/06/2019 | 0 | 0 |
| B | 01/07/2019 | 0 | 0 |
| B | 01/08/2019 | 0 | 0 |
| B | 01/09/2019 | 0 | 0 |
| B | 01/10/2019 | 0 | 0 |
| B | 01/11/2019 | 0 | 0 |
| B | 01/12/2019 | 0 | 0 |
| B | 01/01/2020 | 0 | 0 |
| B | 01/02/2020 | 0 | 0 |
| B | 01/03/2020 | 0 | 0 |
| B | 01/04/2020 | 0 | 0 |
| B | 01/05/2020 | 0 | 0 |
| B | 01/06/2020 | 0 | 0 |
| B | 01/07/2020 | 0 | 0 |
| C | 01/01/2017 | 0 | 0 |
| C | 01/02/2017 | 1 | 12 |
| C | 01/03/2017 | 1 | 12 |
| C | 01/04/2017 | 1 | 12 |
| C | 01/05/2017 | 1 | 12 |
| C | 01/06/2017 | 1 | 12 |
| C | 01/07/2017 | 1 | 12 |
| C | 01/08/2017 | 1 | 12 |
| C | 01/09/2017 | 1 | 12 |
| C | 01/10/2017 | 1 | 12 |
| C | 01/11/2017 | 1 | 12 |
| C | 01/12/2017 | 1 | 12 |
| C | 01/01/2018 | 0 | 0 |
| C | 01/02/2018 | 2 | 2 |
| C | 01/03/2018 | 4 | 10 |
| C | 01/04/2018 | 5 | 17 |
| C | 01/05/2018 | 5 | 17 |
| C | 01/06/2018 | 5 | 17 |
| C | 01/07/2018 | 5 | 17 |
| C | 01/08/2018 | 5 | 17 |
| C | 01/09/2018 | 5 | 17 |
| C | 01/10/2018 | 5 | 17 |
| C | 01/11/2018 | 5 | 17 |
| C | 01/12/2018 | 5 | 17 |
| C | 01/01/2019 | 0 | 0 |
| C | 01/02/2019 | 0 | 0 |
| C | 01/03/2019 | 0 | 0 |
| C | 01/04/2019 | 0 | 0 |
| C | 01/05/2019 | 0 | 0 |
| C | 01/06/2019 | 0 | 0 |
| C | 01/07/2019 | 0 | 0 |
| C | 01/08/2019 | 0 | 0 |
| C | 01/09/2019 | 0 | 0 |
| C | 01/10/2019 | 0 | 0 |
| C | 01/11/2019 | 0 | 0 |
| C | 01/12/2019 | 0 | 0 |
| C | 01/01/2020 | 0 | 0 |
| C | 01/02/2020 | 1 | 0 |
| C | 01/03/2020 | 1 | 0 |
| C | 01/04/2020 | 1 | 0 |
| C | 01/05/2020 | 1 | 0 |
| C | 01/06/2020 | 1 | 0 |
| C | 01/07/2020 | 1 | 0 |
Desired output:
| Company | Date | N accidents | Days off |
| A | 01/12/2018 | 2 | 17 |
| A | 01/12/2019 | 4 | 0 |
| A | ∆ | 100 | - |
| B | 01/12/2018 | 0 | 0 |
| B | 01/12/2019 | 0 | 0 |
| B | ∆ | - | - |
| C | 01/12/2018 | 5 | 17 |
| C | 01/12/2019 | 0 | 0 |
| C | ∆ | - | - |
I think I'm trying to achieve a pretty reasonable thing here...