Is the drill down to hour in date time field possible in Jasper for AWS?



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?




ovais_20's picture
Joined: Apr 29 2015 - 7:04am
Last seen: 8 years 5 months ago

1 Answer:

Hi ovais,

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.




kashoory's picture
Joined: Apr 23 2014 - 5:19pm
Last seen: 2 years 2 months ago