What kind of comparison are you looking for? Is it something like "is the time of this datetime field between starting hour and ending hour?" ?
If that the case you need to extract the hour from your DateTime column. Assuming it actually has the data type of DateTime in Tableau (which means the format doesn't matter) you can write the following
DATEPART('hour', [Your dateTime column name here])
Let's call this Calculation1
If your dateTime was something like this
Calculation1 will give you 15.
Now you can write a calculation like
Calculation1 > StartingHour and Calculation1 < EndHour
This will return TRUE if the hour from your DateTime field is between Start and End Hour.
yes, i am trying to do the same thing..
Let me work on your suggestion. after that i will let you know.
I am trying to create parameter for hour and insert manually hour value like 01:00,01:30
but unable to do this.
Can you send me the correct steps to create hour parameter.
thanks shin.. for your reply.. let me work on this.