Alteryx Designer Discussions

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

Compare Date difference for each ID

Tommy23
7 - Meteor

Hello I would like to have column where the difference (in days) is calculated between each End date for each ID is calculated.

 

Here a example of sample data ( this just an example , how to do it o it can work for various case)

IDEnd date
101/02/2022
101/01/2022
218/01/2022
320/02/2022
419/01/2022
407/01/2022
403/03/2022
118/03/2022
207/01/2022
315/01/2022

 

Here a example of result I want to have

 

IDnb DAYSEnd Date
1001/01/2022
13101/02/2022
14718/03/2022

 

Thanks :)

7 REPLIES 7
binuacs
17 - Castor

@Tommy23 are you looking something like below

binuacs_0-1657032153648.png

 

IraWatt
16 - Nebula

Hey @Tommy23,

You can use a multi row formula to achieve this:

IraWatt_0-1657032181511.png

Any questions or issues please ask :)
HTH!
Ira

 

Tommy23
7 - Meteor

Thanks It work @IraWatt @binuacs 

 

I also put another issues I had on this topic if you have also any idea I will be happy to ear it :)

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-between-period-for-each-ID/m-p/96...

 

IraWatt
16 - Nebula

No worries @Tommy23, I'm having a look at your question now 😃 Also if you find an answer to your question make sure to give it a green tick. 

Tommy23
7 - Meteor

Hello , Do you ave any Idea why I do not have the same result as you? is it because I am located in France and it is because of the time zone @IraWatt 

 

save picture.PNG

IraWatt
16 - Nebula

I'm not sure but it looks like the EndDate_Formatted was sorted descending when it should be sorted ascending?  Any ideas @binuacs ?

binuacs
17 - Castor

@Tommy23 @IraWatt  I think sort tool has the problem based on the result given. @Tommy23 Can you share your output after the first sort tool

binuacs_0-1657176724603.png

 

Labels