Forum Discussion
Group By
Wondered if anyone could put me on the right track. I have a table with 5 columns ID, Present, Authorised, UnAuthorised, Date I want to aggregate the table by the ID between Dates Then calculate...
hello Power-User can you please share a sample of your data without revealing sensitive data?
I have a larger data set but cant upload the pbx file with it in.
| Primary Key | Present | Authorised Absence | UnAuthorised | Mark date |
| Person 1 | 0 | 0 | 0 | 9/5/2022 |
| Person 1 | 0 | 0 | 0 | 9/6/2022 |
| Person 1 | 0 | 0 | 0 | 9/7/2022 |
| Person 1 | 1 | 0 | 0 | 9/8/2022 |
| Person 1 | 1 | 0 | 0 | 9/9/2022 |
| Person 1 | 1 | 0 | 0 | 9/12/2022 |
| Person 1 | 1 | 0 | 0 | 9/13/2022 |
| Person 1 | 1 | 0 | 0 | 9/14/2022 |
| Person 1 | 1 | 0 | 0 | 9/15/2022 |
| Person 1 | 1 | 0 | 0 | 9/16/2022 |
| Person 1 | 1 | 0 | 0 | 9/20/2022 |
| Person 1 | 1 | 0 | 0 | 9/21/2022 |
| Person 1 | 1 | 0 | 0 | 9/22/2022 |
| Person 1 | 1 | 0 | 0 | 9/23/2022 |
| Person 1 | 1 | 0 | 0 | 9/26/2022 |
| Person 1 | 1 | 0 | 0 | 9/27/2022 |
| Person 1 | 0 | 0 | 0 | 9/28/2022 |
| Person 1 | 1 | 0 | 0 | 9/29/2022 |
| Person 1 | 1 | 0 | 0 | 9/30/2022 |
| Person 1 | 1 | 0 | 0 | 10/3/2022 |
| Person 1 | 1 | 0 | 0 | 10/4/2022 |
| Person 1 | 1 | 0 | 0 | 10/5/2022 |
| Person 1 | 1 | 0 | 0 | 10/6/2022 |
| Person 1 | 1 | 0 | 0 | 10/7/2022 |
| Person 1 | 1 | 0 | 0 | 10/10/2022 |
| Person 1 | 1 | 0 | 0 | 10/11/2022 |