BIRT-Adapt dataset on the Value&Category series
I'm working on a report where I must modify my data in order to be displayed in a certain way on chart.
in the following report i have a chart that has dynamic Min/Max value (retrieved from the table).
I have additionally added a dynamic step value as the task requires. The chart displays on the x-axis the data row["value"]. Under this data element there are many values (up to four and can be more for different data). the y-axis displays a value which is not of interest.
What i'm trying to do is:
I'm trying to make chart display on the y-axis -->how many values from row["value"] exist in each Interval or step (Note: the step is set dynamically using chart script). To understand this better please see the following pic:
I believe this can be done but this is honestly out of my experience. I think i should start from BeforeDrawSeries event function but don't now how.
I have found a basic chart API where i can probably modify the x-category and Value-y but still the question is how and where i should prepare the data in order to be able to display them as shown above.
I've posted therefore a draft example in order to make it easier.
Note that I'm using xml-data source as the task requires. Please view the report using HTML to avoid happening an unknown error.
**I would be really thankful if you could share your thoughts or have solution to this **
thanks in advance