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

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
20 - Arcturus

@Tommy23 are you looking something like below

binuacs_0-1657032153648.png

 

IraWatt
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

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

binuacs
20 - Arcturus

@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