Basic Question: Charts

brickuz

Hi,

I have a really basic question.

The data set I want to use returns an output as follows:

PASSED
PASSED
NOT STARTED
PASSED
STARTED
NOT PASSED
...

I want a chart with the possible verdicts (PASSED, STARTED etc.) as distinct values on X and the number of times each verdict occures as Y. In other words:
X = Each unique value (String) from row["verdict"]
Y = The number of occurrences of each unique value

I've tried using aggregation but I haven't managed to get the result I want.

I'm stuck with version 2.2.1 of Birt (fetching data from Clear Quest) if that is useful.

I guess it may be possible to somehow generate an array with the values I want but I can't find out either how or how I when could use it in my chart. I'm familar with Java but pretty new to Birt.

I guess this is really basic but I can't get this to work after a few days of trying and I'm starting to get frustrated .(

BR,
Erik, Ericsson AB

mwilliams

Hi Erik,

If you create a computed column called 'instances' in your dataSet of type 'integer' and have an expression of '1'. You can put 'verdict' on your x-axis and 'instances' on your y-axis. Then, you can add grouping to your chart's x-axis by clicking on the sorting and grouping button next to the x-axis category in the chart editor, with 'sum' as the aggregate expression. This should chart the 4 bars with the sum of the instances.

Hope this helps. Let me know if you have any questions.