We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

Challenge #398: Generating Time Intervals

olga_strubbe
10 - Fireball

A really neat challenge, thank you, @alexnajm!

I employed the same approach as @AkimasaKajitani  - it seemed the most straightforward using fewer tools.  Thank you, Akimasa!!

 

ggruccio
ACE Emeritus
ACE Emeritus

I had the basic concept figured out - just took me longer to get to the answer!

 

Spoiler
398.png
TonyAndriani
9 - Comet

My solution

Spoiler
2023-11-13_17-29-51.png
M__K__A
7 - Meteor

My Solution -- it was good to tinker with the Generate Rows tool, which I don't recall using too often!

Watermark
12 - Quasar
12 - Quasar

Shock of shock I nerded out a little. I decided to create an app so you could select your own time card interval.   

 

 

Spoiler
MT_Solution_398.jpg

balajilolla2
8 - Asteroid
Spoiler
Solution Attached
nSpire
8 - Asteroid
Spoiler
398.png
StevenP
8 - Asteroid

I went and created two flows depending on how "missing" times should be handled:

 

Spoiler
Solution 1 will only generate new rows for data missing between the last provided time and the first provided time. This ignores any times that may have been missing in the middle of the initial dataset.
Solution 2 generates every half hour interval starting from the first provided time and ends at the half hour before the starting time.
Spoiler
image.png

 

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached. Embarassing how long this took... (⊙_☉)

TurboToad
9 - Comet

I skipped the input file. Would probably build this as an analytic app with a start/end time input to build output.

 

Spoiler
398.PNG