Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution. Not sure if there was anything more to calculate as no expected output inside workflow
Solution attached. Took about 10 min.
Used dynamic input tool to get the data from excel sheets, then used find and replace tool to replace values in the lighting condition column, datetime tool with custom expression to convert the field to date, then used a tile tool to capture the time buckets.