kiran_3 Posted February 23, 2015 Share Posted February 23, 2015 i have table name say 'call_records' having sample data as followsid5member_id542call_duration97created2014-11-28 17:00:28statusansweredhere call_duration is varchar(255) i want get the call_duration time and show in a chart like , on x-axis points(call_duration) should be like 0-20 , 21-40, 41-60 and so on and each point will have a bar chart(if i took as bar chart while designing) having height of its count(ex:number of people who spoke between 0-20). how can i achieve this in jasper reprots, i can't really frame the question to search in google but even though i tried didn't get the expecetd solution . i am using jaspesoft studio.here is the query i am using to get call duration for every record.select vmc.created as 'date', vmc.call_duration as 'call_duration' from call_records as vmc where vmc.created between $P{startDate} AND $P{endDate}[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now