News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Segment get time diffe...

Customer experience | Sales, Customer Insights,...

Answered

Segment get time difference between two date time fields

(1) Share

Report

Report

Posted on by Dibyajyoti Jena

Segment - I have a data source, which is having two date time fields.

1. Check in

2. Check out

Now I want to create a segment for all those customers whose checkin and checkout time difference is less than 24 hours.

Any suggestions how can we create the condition in segment to achieve this above scenario.

Thanks & regards,

Dibyajyoti

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (1)

Report

Segment get time difference between two date time fields

Hi,

Comparison of two attributes is not supported in segmentation.
You can create a new column to store the difference between the /CheckIn/ and /CheckOut/ fields.
Then use this column to build the segment.

In my test, I built a custom column to store the days difference.
Then build the segments to find the customers with a day difference greater than 1.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans