|PieChart: All zero/null values [message #717364]
||Sat, 20 August 2011 06:51
| Madhav Suram
Registered: August 2011
We require the following conditions to be met on a pie chart:
(i) Category legend entries should be shown even if the value retrieved from DB is NULL or a zero.
(ii) All zero values should be suppressed from being shown in the chart.
(iii)When all values are zero, then "No data available" message should be shown.
The table being referenced for the pie-chart looks like
The following has been tried:
a) We "suppress" the "zero" values from being displayed but putting a condition for the values. Eg: if (row["VALUE"]==0) null else row["VALUE"] .
Using this the legend entries are visible for the category and the value label is suppressed.
b) Set "Chart Visibility" to show "No data available" message. But this gets displayed only when do data is retrieved from the DB.
c) If we use a "data filter" to show only non-zero/null values, then the is "No data available" message appears, but the legend entries do not show.
So is there a way to show the legend entries(even if values are zeroes) and still show "no data available" message when all the values are zeroes/null? Customer wants to know at all times what all categories(legend) are displayed in the chart even when there are no values and when there are no values then a message should be shown.
We are using BIRT 2.6.2.
Thanks & regards,
[Updated on: Sat, 20 August 2011 15:02]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02427 seconds