Need a sample on MovingAverage

[Amit]

Can anyone post a working sample of MovingAverage.
I am doing :
===================

XYDataset avgds = new MovingAverage().createMovingAverage(ds, "Average", 34, 0);

JFreeChart chart = ChartFactory.createTimeSeriesChart
("AX Success Rate", // Title
"Date", // X-Axis label
"Percentage", // Y-Axis label
avgds, // Dataset
true, // Show legend
true,
true
);

=====================
and I get the following error in the 1st line.
ds is a JDBCXYDataset
=====================
java.lang.ArrayIndexOutOfBoundsException: 2147483647 >= 34
at java.util.Vector.elementAt(Unknown Source)
at com.jrefinery.data.JDBCXYDataset.getXValue(Unknown Source)
at com.jrefinery.data.MovingAverage.createMovingAverage(Unknown Source)
at com.jrefinery.data.MovingAverage.createMovingAverage(Unknown Source)
at testclasses.ChartMaker.percentageSuccessAX(ChartMaker.java:531)
at testclasses.ChartMaker.main(ChartMaker.java:596)

[David Gilbert]

There is a demo called MovingAverageDemo in the distribution.

That said, it looks like you have uncovered a bug...can you supply details of your dataset so I can try to reproduce the problem? Or post a small self-contained application that fails with the same error.

Regards,

Dave Gilbert

[Amit]

JDBCXYDataset ds = new JDBCXYDataset(DatabaseManager.getConnection());
ds.executeQuery("Select eventdate, (replace(TotalAXSuccess,0,1)/replace(TotalAXReceived,0,1) * 100) as SuccessRate from DailyProcessedQuery");

XYDataset avgds = new MovingAverage().createMovingAverage(ds, "Average", 34, 0);

JFreeChart chart = ChartFactory.createTimeSeriesChart
("AX Success Rate", // Title
"Date", // X-Axis label
"Percentage", // Y-Axis label
avgds, // Dataset
true, // Show legend
true,
true
);


ChartUtilities.saveChartAsPNG(new File("AXPercentageSuccess1.png"), chart, 1000, 600);

} catch (SQLException e) {
e.printStackTrace();
} catch (Exception ex) {
ex.printStackTrace();
}

[Amit]

Can anyone please help on this ?

Thanks

[David Gilbert]

It is difficult to trace the error because I don't know what is returned by your query.

Regards,

Dave Gilbert

[Amit]

Sent you an email with the data returned.

Thanks