Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
Had a good refresher on generate rows!
Had a good refresher on generate rows!
Interesting challenge! Do note you have 6 data inputs to linked, took me awhile to realize that I was working with 5.
That took me way too long, but I got there.
Spoiler
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
- 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
