# Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
###### ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

## Time elapsed between two dates in different rows

Highlighted
7 - Meteor

Hello all,

I am looking for a way to know the interval of days between two dates.

The status of one ticket should pass by different stages and I need to know how many days was the ticket on each status, kindly note that a ticket can repeat the same status, in that case I need to know the summary of the days with same status. so what I need is to know how many days are each ticket in each status.

 TICKET TIMESTAMP STATUS 123 2020-01-22 A 222 2020-01-22 A 123 2020-01-23 B 321 2020-01-24 A 222 2020-01-25 B 123 2020-01-25 B 321 2020-01-26 B 123 2020-01-30 C 321 2020-02-02 C

Kindly note that Timestamp refers to the date when this information has been entered to the sheet.

With this scenario the results that I want is the below chart. (the numbers in the status columns are days)

 TICKET STATUS A STATUS B 123 1 7 222 3 0 321 2 7

Do you know how can I calculate this ?

Also if you could add a formula to calculate this only in business days will be much appreciated.

Highlighted
12 - Quasar

Great question.

However, why do you have ticket 123 marked twice in Status B?

Sincerely,

Jacob

Highlighted
7 - Meteor

Yes, sometimes the status cannot be changed and it is tracked as the same status before.

I know that maybe I cannot get the chart I need. if so it is acceptable to have this below:

 Ticket Status Days 123 A # 123 B #

Thanks for your time

Highlighted
Alteryx Certified Partner

Hello @Dario02,

Would this help?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
12 - Quasar

I've built you a workflow with a Batch Macro.

Please let me know if it helps. If it does, please accept this as a solution.

Thank you,

Jacob

Highlighted
12 - Quasar

slightly different (and more complicated) path, but one I believe is necessary in order to calculate business days.

In short:

Scaffold all the available dates in each ticket status, and then count the days that are business days.

Highlighted
7 - Meteor

Many thanks for all the help, I has been able to do what I want thanks to your help.

Highlighted
7 - Meteor

Unfortunately I was not able to open your workflow because I was using an older version of Alteryx.

But I appreciate your prompt reply and help.

I hope it could help somebody else in the future.

Have a great day.

Labels