This content has been marked as final.
Show 3 replies
-
1. Re: How to use a specific DateTime as datetime range Quick Filter?
Shinichiro MurakamiJul 6, 2016 12:04 PM (in response to owen walker)
You seems right. Slider only shows "Day" level of filtering.
Another approach is changing the datetime into day level with below formula.
And put this field in filter shelf.
[Date 6 hours shifted]
dateadd('hour',-6,[Time])
Thanks,
Shin
9.0 attached.
-
600am_filtering_9.0.twbx 24.8 KB
-
-
2. Re: How to use a specific DateTime as datetime range Quick Filter?
owen walker Jul 6, 2016 12:36 PM (in response to Shinichiro Murakami)Ahh.. makes sense!
Had to convert my data type to date only to ensure it didn't show the times and kept things tidy as well but it works now.
Awesome
-
3. Re: How to use a specific DateTime as datetime range Quick Filter?
Shinichiro MurakamiJul 6, 2016 12:38 PM (in response to owen walker)
Yes, it's easier to change the type to date instead of datetime after 6 hours shifted.
Good job !!
Shin