I have used Jasper for AWS with Redshift at its backend. Now, I have made a aggregated table having datetime and counts. There is a hourly interval between datetime values in datetime column like this:
2015-04-25 13:00:00 | 32 | 45 | 90
2015-04-25 14:00:00 | 32 | 45 | 90
2015-04-25 15:00:00 | 32 | 45 | 90
Now I have developed an adhoc view for this and get the report having Day as X axis and SUM of my aggregates on Y axis. The X axis is not drilling through the datetime values but showing Day aggregates. Is there anything that I have missed?
In adHoc design view, do you put the data/time field in "Rows"? If yes, right-click on the date/time field that located in "Rows", from "Change Grouping" choose the option suits you which in your case it looks like "Hour By Day" is the right option. Please note that if you choose "Hour", result would be aggregated on hours which does not seem to be what you want.
If you do not put date/time in "Rows" please give more detail.