Filter Data by Hour

[GaryChin]

Hi All,

I have a timestamp field in 'YY/DD/YYYY hh.mm.ss' format. And only want to set analysis the data form 9:00 AM to 6:00 PM. How can I do it in Filter Data 

Or in a filter pane

Thanks

Gary

[Vegar · Accepted solution]

What if you create a filter pane with this dimension expression?

=MakeTime( hour(timestamp# ([Your Field], 'YY/DD/YYYY hh.mm.ss')), minute(timestamp# ([Your Field], 'YY/DD/YYYY hh.mm.ss')))

[GaryChin]

Dear Vegar,

Thank you for your help.

I modify it to add a new field :

MakeTime( hour(timestamp([My_field], 'YY/DD/YYYY hh.mm.ss'))) 

and the result is what I need.

Thanks