johncat Posted June 8, 2015 Share Posted June 8, 2015 I have the following data rows being returned from a json webservice:bugId, OpenDate, CloseDateI would like to plot a line chart with date along the x-axis and a count of the number of bugs opened on that date and the number of bugs closed on that date, is this possible in jasper reports? I can create two separate charts using the html5 chart: - level = OpenDate (or CloseDate) - measure = count(bugId)What I am unable to do is combine the date fields, essentially I need UNION two queries to pull back open tickets and closed tickets as seperate rows but as this is a REST API I cannot achieve this in the datasource so are looking for alternative options within Jasper Reports itself 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