Forum Discussion
Anonymous
4 years agoNot applicable
How to filter out same day with 2 datetime coumn
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...
- 4 years ago
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.
Syk
Resident Rockstar
4 years agoAdd 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.
- Anonymous4 years agoNot applicable
thanks, it works