Hourly Granularity

We have a need to look at transactions per hour and slice data at the hour and in some cases minute level. Currently we have to create a new column for hour number and filter on that, but it doesn't allow for the same level of time intelligence. We would love the ability to include hour in the date/time hierarchy