How to Calculate Date Difference Between Aggregate Date with Non Aggregate Date

Question & Answer
,
1

Hi Team,

Trying to create a calculated field where I want to take the Date Difference between the Aggregate Field Date and Non aggregated field date.

E.G - dateDiff({Created Date}, {Max(End Date)},''DD")

Thanks & Regards
Biswajit Dash

2

Hi @Biswajit_1993

Will the create date be same at the visual grouping level ? .
If yes then we can do max on both the dates and get the diff .

Can you please include sample data and with usecase details to look into the details.

Thanks
Vinod

1 Like
3

Hi @apjvinod , Thanks for your reply I need the Time duration between the Created Start Time & Max End Time .

image

And secondly need to aggregate as End Date as month & it is the aggregation of all the Duration value for the respective month.

image
image943×359 11.2 KB

Thanks & Regards
Biswajit Dash

1 Like
4

Hi @Biswajit_1993! In the sample data screenshot you have End Date populated for each Item and Created Date combination. Why would you need to do a max(End Date) to compute date difference between Created Date and End Date? You should be able to use dateDiff({Created Date}, {End Date},''DD").
For the second part create a calculated column for truncating End Date at month level using truncDate(‘MM’, {End Date}) and use this calculated column as the partition to compute sumover of Duration value.

Hope this helps!

Regards,
Karthik

1 Like