Chart the Distribution of Values

HI,

I'm new to BiRT and have some problems concerning charts. I'm using birt version 2.2.2 and the eclipse "Report Design" to build my Report.

Now I'd like to make a chart that shows the normal distribution of values. Background is Finance and I'd like to show the distribution of Returns in a Chart.

Unfortunately I didn't find a way to do this directly in eclipse/birt with all return values as input (raw data, not grouped).

Is this possible with BiRT ?

Thanks a lot for your help!
regards alex

Find more posts tagged with

Comments

mwilliams

Hi Alex,

Can you please explain more of what you're looking to do? What does your data look like?, what are you wanting to see?, etc. Thanks.

alex_

Hi, thanks for your reply.

I have a simple series of returns represented in Table-cloumn. The Table looks like:

ID | Value

e.g.
1 | 0.014
2 | -0.173
3 | 0.124
...

So this are just the raw return values. Now I'd like to plot a chart which shows the distribution of the return values (usually in a bar chart). The chart should now automatically divide the value range into n-bins and assign the number of return values that are between 2 of them.

Here is a small example:
"http://trend-chart.com/images/prdis.gif"

The x-axis shows the returns (the bins) and the y-axis shows the number of returns that are within this bin.

regards alex

mwilliams

Alex,

So, you determine the bin based on a range? If this is the case, you can add a computed column to your dataSet that assigns a "bin #" based on a row's "value" column. Then, in your chart, you could group by this "bin #" and have an aggregation of count. Let me know if I'm not understanding correctly.