Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to calculate number of days using two columns in a logic

Oskido
7 - Meteor

Hi,

 

I would like to use the attached sample to determine number of days.

 

For an example, in the attached sample I have two columns with Date (sorted in ascending order) and Skill.

This is the same record but has been reassigned to different skills multiple times.

 

I would like determine:

 

How many days from the day of receival on "UWGLSERVSA" skill until first  "BO. BaNCSCB. Reinstatement. SA" skill as highlighted in the sample.

 

Would it be possible using In-Database tools?

 

Thanks

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @Oskido 

 

Here's one way. In-DB tools would depend on your DB and process.

 

image.png

Labels
Top Solution Authors