Process:
- Sorted records (not doing this right away was one of the mistakes I made early on)
- Create "Remove Date" field to be one day prior to the subsequent install date (the other mistake I had made early on was in assuming that different manufacturers meant different output, so I had grouped by manufacturer)
- Created "Currently Installed" record where Remove Date was null
- Union of all Rot-Circ Hours inputs
- Joined two streams by "Rig"
- Created Rotating Hours and Circulating Hours fields
- Created Removed Date field to be one day later than Remove Date
- Filtered out data outside of relevant date range
- Summed Rotating Hours and Circulating Hours with data grouped by just about everything else