Skip to main content



      Home
Home » Archived » BIRT » Problem with Legend in Graphs(When all data is in one direction, bar and pie show only one legend item.)
Problem with Legend in Graphs [message #1779057] Sun, 31 December 2017 07:32 Go to next message
Eclipse UserFriend
When all data is in one direction, bar and pie show only one legend item.
Should show both legend items (even if one is not present in the chart)
How can this be fixed?

This is how it looks OK:
index.php/fa/31702/0/

This is how it looks WRONG:
index.php/fa/31701/0/

Attached are project files (I tried to delete most of the irrelevant code).
creatirea is: <amad>
either:
<amad>1</amad>
ot:
<amad>0</amad>

Hope this is clear and someone has a solution for this.

Many thanks
Yosi

Re: Problem with Legend in Graphs [message #1779671 is a reply to message #1779057] Wed, 10 January 2018 22:06 Go to previous message
Eclipse UserFriend
Hi there. You probably need to build your data so you always have the series present even if there is no data for it.

for example, create a reference table that contains the values 'Right' and 'Wrong', then in your main query do an outer join based on the reference table so you always end up with a row for each category regardless of whether there is any data.

FWIW - I am an BIRT n00b, but I know a bit about SQL. The problem you are describing is a classic in SQL (for example, how do I make a query return sales per week even when there are no sales in a particular week. The easiest answer - use a reference table of weeks).

Previous Topic:BIRT datetime function
Next Topic:Emitter in BIRT Runtime
Goto Forum:
  


Current Time: Thu Jul 03 20:37:50 EDT 2025

Powered by FUDForum. Page generated in 0.03156 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top