vasu_murthy

Time Series charts does not display all the X-axis intervals, which the attached query returns: We are currently evaluating the jasper server, to incorporate into our application. Through iReports 3.0.0 designer, I am using time series charts to display stacked line chart. On X-axis i am using datetime field returned by the query. Y-axis is mapped to the count of rows, and the stack of various colors depend on other field returned by the query which is set to the series expression. Chart Properties >> Chart Data >> Details >> Time period >> "Day" is selected. When the query attached to the chart returns data for a period of 2 days, the time series chart shows only X-axis intervals for the first day and does not show X-axis points for the second day. The chart should ideally show X-intervals of both 2 days data, even though it might be splitting the time period into hours(Note that Time period is selected as "Day"). The X-axis shows only intervals of first day with duration in hours and does not show the second day data. Interestingly, if the query returns data for more than 2 days i.e., 3 or more days, the chart appears to be displayed as expected. Other observation is that, if we reduce the size of the X-axis to a very small extent, the X-axis plotting changes to per-day which was earlier showing per-2 hours before reducing the chart width. Any suggestions in this regard would be highly appreciated.

Hi, I am using time series charts in iReports designer 3.0.0 to display time in X-axis , count of rows in Y-axis and Series expression to show in various colors. The issue i am facing is that, if i query the database for 3 days time period and it returns quite a number of rows as follows: Day 1 -- 3 rows Day 2 -- 0 rows Day 3 -- 5 rows The line drawn by the time Series chart now directly plots from Day 1 to Day 3, i.e., from value 3 to 5 in Y-axis. Ideally the line should start at point 3 on Day 1, touch zero on Day 2 and then reach 5 on Day 3. But the way currently the time Series chart behaves is, zero points are ignored in between two non-zero points. In my example it should touch zero point on Day 2 even though my query did not return any rows on that day. The way the time Series chart plot now joins Day 1 value (3) with Day 3 value (5) and it gives a false impression that Day 2 Y-axis value might be 4, which should have been zero. Please let me know if you faced this kind of scenario and do I need to provide any more details on the issue. Thanks Vasu