Jump to content
Changes to the Jaspersoft community edition download ×

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


ovais_20
Go to solution Solved by kashoory,

Recommended Posts

Hi,

 

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?

Thanks.

 

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

  • Solution

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.

Regards,

Keivan

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...