nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using datatables groups and values in chart.

hesher

Hi,

I have a few data-tables (one per each report) which I would like to base some charts on.
I could not find a way to create a chart that uses the groups and aggregated values from an existing datatable.

It's kind of a hassle to redefine groups for every chart.
Is there a way to bind a chart to an existing data-table?

Tnx!

Find more posts tagged with

Comments

johnw

You have always been able to use the data in a table on a chart. You would select "Inherit Data from Container" under the data tab in the Chart builder. 
 
In BIRT 2.5.x and above, you can also inherit the grouping data as well. When you select "Inherit Data from Container", there will be a drop down box that lets you select "Inherit Columns and Groups". Aggregations are also usable. 
 
John 
 
<blockquote class='ipsBlockquote' data-author="'hesher'" data-cid="66135" data-time="1278251434" data-date="04 July 2010 - 06:50 AM">
Hi, 
 
I have a few data-tables (one per each report) which I would like to base some charts on. 
I could not find a way to create a chart that uses the groups and aggregated values from an existing datatable. 
 
It's kind of a hassle to redefine groups for every chart. 
Is there a way to bind a chart to an existing data-table? 
 
Tnx! </blockquote>

hesher

<blockquote class='ipsBlockquote' data-author="'johnw'" data-cid="66136" data-time="1278276574" data-date="04 July 2010 - 01:49 PM">
You have always been able to use the data in a table on a chart. You would select "Inherit Data from Container" under the data tab in the Chart builder. 
 
In BIRT 2.5.x and above, you can also inherit the grouping data as well. When you select "Inherit Data from Container", there will be a drop down box that lets you select "Inherit Columns and Groups". Aggregations are also usable. 
 
John </blockquote>
 
Thanks John. 
Do I have to place the chart inside the table for it to inherit the columns and groups? 
As an example, I have a table with 200 children of various heights and I create a table which groups them by ****. 
so.. 
original data would be something like a set of (Height,****) and after grouping (and deleting the detail row) I get this table: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
**** Avg Height Deviation from Total Avg
Male 175 6
Female 165 -4
</pre>
And say I want to create a chart that display the 'Deviation from Total Avg' in columns (2 Columns in this case), Where would I place the chart in my report? 
 
If I place it in the group footer it will show 2 seperate graphs, If I place it in the table general footer, I'm not sure I can display the data. (Maybe I'm wrong) 
 
Hope I'm making myself clear. :-) And thanks again for the help!! 
 
UPDATE - <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1157-birt-using-table-aggregations-in-a-chart-example/'>This</a>example answeres my qustion