How can I change the aggregation method for the Y axis in Birt chart

#1

I am using Knime 3.71. I want to create a BIRT chart where the value of the Y axis is averaged. But I cannot changed it, the current value is set to sum and it is greyed out. Thanks.

0 Likes

#2

Hi @abis866k,

this is something related to some changes in BIRT and Eclipse (https://stackoverflow.com/questions/42659190/birt-summation-button-disabled/42701299). Unfortunately there is not much we can do about it, but there is a workaround.

In the XML source of your report you find elements related to the chart. Choose the one which has the group column (the one with values for the x-axis) in the element and change the the value of to Average.

This will not change or enable the icon in the configuration dialog, but in the chart itself it will be used as aggregation function per group.

Does that help?

Best,
Marten

1 Like