How to filter out same day with 2 datetime coumn

[Anonymous]

Hello, 

My dataset has 2 datetime column like this, I would like to create a new column shows how long it take from Cart to when the sale is completed. I want to filter out that the date in Sales Order Date is the same day with Cart Created On because there is some row that are in different days. I need to calculate the difference time between these 2 columns with the filter is the same day. 

Sorry for my English if it's not clear. 

Thanks a lot 

[Syk · Accepted solution]

Add a column to get your duration by subtracting the times

Then click the arrow next to your new column > duration filters > greater than and enter 1 (for 1 days) which will remove all of your same day data.

[Anonymous]

thanks, it works