How do you control the Y axis in a custom chart?

[awright]

I am trying to create a custom chart that trends data from a Trend Job that runs every hour.

I want to make the X axis the hour that the data was collected on (which I have done using "collected" as the column, and that works fine), and I want to make the Y column display the Value field of the trend data.

This is the problem: I am unable to make the Y column display the numbers within the value field. At the moment, the Y column only displays the COUNT of Sys Trends, not the Value contained within them.

Any suggestions on how to make this work? I have been trying to look at the jfreechart API but it is rather large and I am not sure where to start.

[awright]

More specifically, how do you set a range on the Y axis based on numerical data from the table generated by a Scheduled Report Summary Generation

[awright]

It turns out that in the Report Summary Lines table, the Value field controls data along the Y axis and Name field (or possibly the Category field; i filled in both with identical data) controls data along the X axis.

You won't go far wrong by manually creating an entry on the "sys_report_summary table" which contains a load of related "sys_report_summary_line"s whose Value and Name/Category fields contain the data you want along the X and Y axes.

(Don't forget to make sure that the lines are associated with the summary and the summary is associated with the report generation as part of your generation script.)