Start Time and End Time from a data set

[udles5666]

Hi Community

I tried to use Min & Max function of Summary tool in the attached workflow but it doesn't seem to work. 

I am looking for the below output from the data set but not sure why Min & Max does not work the way I think it should. 

Can someone please have a look and help? Thanks, 

[Emil_Kos]

Hi @udles5666,

Please verify if that is exactly what you need but I think this should solve your problem. If not the container in the workflow should give you an idea of how you can solve the problem that you had. 

Using the summary tool you can't have both MAX and MIN number at the same time because it will not work as you wish.

Please let me know if this was helpful. 

EDIT: After looking at @grazitti_sapna solution I realised that my solution will give you an answer showing the max date and min date but the case date will be different.

I was thinking that you wanted to see the max and min date but looking at the desired output I think my answer will not show what you need. 

[grazitti_sapna · Accepted solution]

Hi @udles5666 , try this.

Further if you are looking to connect this with the input data, try this.

Thanks.

[udles5666]

Hi @grazitti_sapna 

How do I add a location filter on Min Time and Max Time in the attached? Please read the scenarios below I want to cover in the logic. Attached spreadsheet and workflow package for reference. 

Scenario: 

We only have two main entrances (HMGBR5_Main_IN & HMGBR5_SNEAK_IN) & Two exit doors (HMGBR5_Main_OUT & HMGBR5_SNEAK_OUT)

• BATMAN - Uses HMGBR5_SNEAK_IN to come in on 12:22:57 a.m so this will be his start time on 13-09-2020 & uses Main_Out to go out at 9:59:55 a.m which will be his finish time.

• Charlie - He works night shift. (4pm - 4am next day) Comes in through HMGBR5_Main_IN at  16:16:15 p.m. which will be his start time but doesn't leave that day. The entry for 13/09/2020 3:03:57 a.m. is for the previous day. 

Desired Output : 

One row per day, per card number. 

Potential Case Card Number	Potential Case Name	Company	Case Date	Start Time	Finish Time	Entry Gate	Exit Gate
59960	Charlie	Holly Molly Guacamoley Brands (AU) Ltd	13/09/2020	16:16:15 p.m.	null/blank	HMGBR5_Main_IN	null/blank
59994	Batman	Holly Molly Guacamoley Brands (AU) Ltd	13/09/2020	12:22:57 a.m.	9:59:55 a.m.	HMGBR5_SNEAK_IN	HMGBR5_Main_OUT

Thanks, 

[kapilthakur]

@Emil_Kos @udles5666  Can you share the formula, I don't have alteryx installed but I wanted to know the formula how it's been used in such scenarios.

[kapilthakur]

@grazitti_sapna  Can you please share the formula as a snip. It would be great help for me.