Forum Discussion
johnlhaase
5 years agoHelper I
Count Occurrence with Index
Hello I am working with a limited data set. I need to create a grouped index and my thought was to count each occurnace and fill down thereby giving me set or groups to work with. In my table be...
johnlhaase
5 years agoHelper I
FlightDayFlightDaysAssignmentFlight2PICSICOver-20 PICHoursHours3
| 3000 | 1 | 1 | Duty | Show Time | 1 | 2 | 0 | 15 | |
| 3000 | 1 | 1 | Block | Flight | 1 | 2 | 0 | 13 | 13 |
| 3000 | 2 | 2 | Duty | Show Time | 1 | 2 | 0 | 18 | |
| 3000 | 2 | 2 | Block | Flight | 1 | 2 | 0 | 12 | 8 |
| 3000 | 3 | 3 | Duty | Show Time | 1 | 2 | 0 | 14 | |
| 3000 | 3 | 3 | Block | Flight | 1 | 2 | 0 | 12 | 12 |
| 3000 | 4 | 4 | Duty | Show Time | 1 | 2 | 0 | 6 | |
| 3000 | 4 | 4 | Block | Flight | 1 | 2 | 0 | 4 | 4 |
| 3000 | 5 | 5 | Duty | Show Time | 1 | 2 | 0 | 16 | |
| 3000 | 5 | 5 | Block | Flight | 1 | 2 | 0 | 14 | 14 |
| 3000 | 6 | 6 | Duty | Show Time | 1 | 2 | 1 | 22 | |
| 3000 | 6 | 6 | Block | Flight | 1 | 2 | 0 | 15 | 8 |
| 3000 | 7 | 7 | Duty | Show Time | 1 | 2 | 0 | 17 | |
| 3000 | 7 | 7 | Block | Flight | 1 | 2 | 0 | 13 | 12 |
v-kelly-msft
5 years agoCommunity Support
Hi johnlhaase,
Could you pls also provide your expected output based on your sample data?Best with your logic.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!