In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate Hours for missing rows between time interval

Joker_Hazard
11 - Bolide

Hi all.

 

I'm struggling with creating a formula in Generate Row tool for missing hours.

 

Ranges should be between 06 A.M to 19 P.M

 

Some Clients start with 8 A.M but I need ranges with 0 values at 6 and 7 A.M

Some Clients end with 17 P.M but I need ranges with 0 values at 18 and 19 P.M

 

Tried two constants and using it as formulas but still can find a way to measure it properly.

 

How the dateset is made of:

Joker_Hazard_0-1673814258987.png

 

Desired output:

 

Joker_Hazard_1-1673814399678.png

 

Thanks in advance

 

 

2 REPLIES 2
binuacs
21 - Polaris

@Joker_Hazard One way of doing this

 

binuacs_0-1673816729845.png

 

Joker_Hazard
11 - Bolide

As always @binuacs  thank you very much

Labels
Top Solution Authors