Challenge #186: Drilling down into Data Analysis

[laeorn]

Révélation

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.

[SueDonim]

That took me way too long, but I got there.

Révélation

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

[cc000072]

Here is my solution. Workflow became a bit complex

[PhilipMannering]

Boring but not boring.

Révélation

Workflow

[BlazB]

First submission ever! Fun challenge.

Révélation

 

[NoraW]

 

Révélation

[DanielMS]

Hi All,

This was a challenging one

Révélation

[AMansour]

Révélation

[dombaikamilla]

Révélation