Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Periods define by start and end date

jajuele
7 - Meteor

Hey guys,

 

do you know how I could first define a period with one start date and one end date ( both in yyyy-mm-dd , hh:mm:ss).

 

The next Problem is that i have to calculate accordances of three or more periods as an percentage. Do you know how to do this ?

 

Hope you can help me and staysafe.

 

 

7 REPLIES 7
ydmuley
12 - Quasar
12 - Quasar

Hello @jajuele not clear with the question. Could you please clarify with an example?

 

Thanks,

Yug

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
jajuele
7 - Meteor

Hello @ydmuley,

 

I`ve got an Station A: it has 6 different Dates 1. Start of door open 2. End of door open 3. sign in ( allowed to do work) start 4. sign out (allowed to do work) end 5. Station doesnt work start 6. Station doesnt work end . Now I want to create a period from start / end of door open. Same method for sign in/ out and Station doesnt works start/end .

 

In the End i Want to  divide the period of door open by the period of sign in and divide the period of sign in by the period of Station off. That are Kinds of  Service Quality indicators.

 

I´ ve attached an example. Same Things I want to repeat for other stations.

 

 

kaushik_birmiwal
7 - Meteor

@jajuele 

 

Can you please a sample formula solution in excel? also please share data for few more stations, that would help check if calculations work fine. 

 

Regards,

Kaushik

jajuele
7 - Meteor

@kaushik_birmiwal

 

I`ve attached a new Excel File with more stations. In the last two Collums I`ve calculated the percentages manually( just with minutes - results could be a bit different):

 

Hope you can help me with my Problem.

RolandSchubert
16 - Nebula
16 - Nebula

@jajuele ,

 

I'm not sure, if I completely understood  the problem. In my understanding, you want to calculate the share of one period (e.g. "Sign in") in another period (e.g. "Door open"). I've attached a sample workflow calculating length of periods and shares   - what do you think?

 

Best,

 

Roland

jajuele
7 - Meteor

Hi @RolandSchubert , thanks for your answer 🙂

 

generally thats my Idea, but theres one Problem: there are a few Examples where the Timelines dont cut each other. For example: (sign in start  14:00:00, sign in end 14:30:00) and (Station off start 14:40:00 ,Station off end 15:10:00). With your calculations it should be 1. But I want  the overlapping of the periods. That means in this Example there is no overlapping of those timelines.

 

I`ve attached an example: I want to get the cutting period of those incidents to calculate the percentage  (sign in to door open). I want the percentage of the sign in covers the door open.

 

Hope you understand.

 

Best

 

Jan

RolandSchubert
16 - Nebula
16 - Nebula

Hi @jajuele ,

 

I've added some checks to ensure, that only overlapping periods are considered. Check it out, hopefully it works now as expected.

 

Best,

 

Roland

Labels