Add chart in table groups

Hi,

I want to add chart in a table with two groups.

The scenario is:
The table is grouped on two variables x and y.

x |
| y | aggr1 | aggr2 | CHART

Aggr1 and Aggr2 are aggregated values displayed along with second group header.
I want to add a chart alongside to give a better idea of comparison for those values.

Can someone suggest how to go about this.

Thanks,
Vash

Find more posts tagged with

Comments

mwilliams

Hi Vash,

Have you tried setting this up yet? What problems are you having so far?

vash

Hi Michael,

I actually got that layout, but now I want a new layout.

I have two groups.

Existing layout:

Group1 Header - | x |
Group2 Header - | | y | value1 | aggr1 | more values | - Filter condition show TOP 6
Group2 Header2 - | i have a chart here | - so the charts are drawn for TOP 6

Desired layout:

Group1 Header - | x |
Group2 Header - | | y | value1 | aggr1 | more values | - Filter condition show TOP 6
Group2 Header2 - | chart1 | chart2 |

Since I am doing TOP 6, the charts do not fit on one page.
For each grouping I want to dedicate one page.
So I thought it would be nice to show 3 - 3 charts on half a page.

I calculated a running count for 'y' and tried to apply a filter condition on the chart.

But I get the following error:

Chart NewChart1:
+ The filter definition using expression "row["count"] % 2" is not valid.
A BIRT exception occurred: There are errors evaluating script "row["count"] % 2":
Invalid bound column name: count. (<inline>#1).. See next exception for more information.
There are errors evaluating script "row["count"] % 2":
Invalid bound column name: count. (<inline>#1).

Where count - runningCount on 'y'

Can you suggest, a solution for this?

Thanks,
Vash

mwilliams

Vash,

Can you attach your report design so I can get a better idea of how you're setting it up? I won't be able to run it, but I'll be able to see the setup. What version of BIRT are you using?

vash

Hi Michael,

I am using version 2.3.1
I have attached my report design.
For now in my design I just have one chart - with the filter condition - for trial purposes.
But if it works, as I mentioned I would like to display charts side by side in the header row.

Thanks,
vash

mwilliams

Vash,

So, you want all 6 charts to be in the group header? 3 in one row and 3 in another?