News and Announcements icon

Dynamics 365 CommunityForums Customer Insights - Data forum Segment get time diffe...

Customer Insights - Data forum

Suggested answer

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

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

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

News and Announcements

Just out! June 2024 Dynamics 365 Community Newsletter

Community forum and blog attachments are now available!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 284,876 Super User

#2

Martin Dráb 225,425 Super User

#3

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans