Jump to content
Changes to the Jaspersoft community edition download ×

Aggregated time charts


jmbaker

Recommended Posts

Hello,

 

Would anyone be able to give some pointers on how to create a chart with time bandings on the X axis and aggregated values on the Y axis? For example, consider this data:

 

time user

100 X

100 Y

110 X

110 Z

120 Z

130 Y

130 X

130 Z

 

Would produce a graph with (for arguments sake) four time bands with values:

 

100-110: 2

110-120: 2

120-130: 1

130-140: 3

 

Of course, I will have lots of time data and the bands will be controlled by the 'Time period' drop down in a 'Time series dataset'.

 

Any thoughts would be most welcome.

 

 

John

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

So perhaps I can expand my question - how do I sum something in Jasper? Are there any kind of aggregation abilities at all? I can't believe this isn't really easy given aggregation must be a common task (I am assuming I just don't know how to do this!).
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...