Jump to content
Changes to the Jaspersoft community edition download ×

timeseries chart changing the timeperiod


oomsb

Recommended Posts

Hello all,

I have a query returning : number of products[number], day [date]

When printing it on a time series chart using a timeperiod of day, the results are printend as expected.

When chaging the timeperiod to month, I would expect that jasperreports would print the totals per month(do the sum of number of products for +/-30 days), but now I see a wrong result .

My query : 

select count(tbl.userid),to_date(to_char(tbl.day,'YYYYMMDD'),'YYYYMMDD') as dag from (select min(starttime) as day, userid from job group by userid) tblgroup by  dagorder by dag asc[/code]
            <timeSeriesChart>                <chart evaluationTime="Report">                    <reportElement x="7" y="31" width="540" height="200"/>                    <chartTitle/>                    <chartSubtitle/>                    <chartLegend/>                </chart>                <timeSeriesDataset>                    <timeSeries>                        <seriesExpression><![CDATA["SERIES 1"]]></seriesExpression>                        <timePeriodExpression><![CDATA[$F{dag}]]></timePeriodExpression>                        <valueExpression><![CDATA[$F{count}]]></valueExpression>                        <labelExpression><![CDATA["label"]]></labelExpression>                    </timeSeries>                </timeSeriesDataset>                <timeSeriesPlot>                    <plot/>                    <timeAxisFormat>                        <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/>                    </timeAxisFormat>                    <valueAxisFormat>                        <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/>                    </valueAxisFormat>                </timeSeriesPlot>            </timeSeriesChart>[/code]

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...