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; } } }

A bar chart with 2 group names as x-axis values ?

germobirt · 2012-05-03T10:07:56+00:00

germobirt

I've a bar chart based on a table with 2 groups. 
 
I have a db query with that 2 column data 
 
Theme | InTime

Theme A | Yes 
Theme A | Yes 
Theme B | Yes 
Theme B | No 
Theme A | Yes 
... 
 
I have a birt report table with 2 groups (Theme and InTime) and a count aggregation on Yes and No 
 
Theme A 
<ul class='bbc'><li> Yes 10</li><li> No 15</li></ul>
Theme B 
<ul class='bbc'><li> Yes 20</li><li> No 35</li></ul>
Theme C 
<ul class='bbc'><li> Yes 12</li><li> No 40</li></ul>
Theme D 
<ul class='bbc'><li> Yes 06</li><li> No 33</li></ul>
 
 
I have a bar chart that shows me the Yes and No counts for each theme. 
 
It looks like that 
The names of the 2nd (aggregated) groups are under the bars. 
 
 
10 | 15 | 20 | 35 | 12 | 40 | 06 | 33

Yes | No | Yes | No | Yes | No | Yes | No 
 
 
But I need a bar chart like that. 
The name of both groups under the bars. 
 
 
10 | 15 | 20 | 35 | 12 | 40 | 06 | 33

Yes | No | Yes | No | Yes | No | Yes | No 
Theme A | Theme B | Theme C | Theme D 
 
 
or even better only the 2nd groups 
 
 
10 | 15 | 20 | 35 | 12 | 40 | 06 | 33

Theme A | Theme B | Theme C | Theme D 
 
 
For to see which bar is Yes and wich is No I want to color them in green(Yes) and red(No) 
 
 
In Crystal Report I've achieved that. 
There I can define for the data "On Change of : 1.) Theme & 2.) InTime" 
 
Now I'm using Birt 2.6.2 
 
How can I get a bar chart like the 2nd and 3rd example? 
 
 
best regards

Find more posts tagged with

Comments

mwilliams

Take a look at this design. It does the last option. I didn't do the colors, but you should be able to do that easily with the chart palette or script. Let me know if you have issues.

germobirt

Yupp, that's it!
<New Series...> is what I needed.
And the 2 footer rows is better than my 1. try with one.

thanks thanks ...

mwilliams

You're very welcome. Let us know whenever you have questions!

shyamgoda

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="101244" data-time="1337796675" data-date="23 May 2012 - 11:11 AM">
You're very welcome. Let us know whenever you have questions!

</blockquote>
 
Hello MWilliams, 
I have a similar requirement with a little twist. The grouping "MGRGROUPING" on my table is based on Manager_ID, whereas I want to display the corresponding Manager_Name on the Chart's X-Axis. I used row["MGRGROUPING"] for X-axis and 2 group-level calculated column-bindings in the Y-axis series. 
 
How to achieve this? Thanks in advance. 
 
regards, 
Shyam

mwilliams

You could always store the manager name in a persistent global variable in your dataSet script and name the pgv by the manager id. This way, you can recall the pgv with the current label value and replace the label with the name. That's one option. Let me know if you have questions.

shyamgoda

Thanks for the suggestion. I shall try to implement that way. I suppose that you meant to access the pgv in the "beforeDrawAxisLabel" kind of event for each label? In my report, I would have multiple sets of MgrID/MgrName per report generation. Is it ok to set so many pgv's or do you suggest using an array?

Is there any other way to access the corresponding value from the table-group or dataset itself?

BTW, I had tried using pgv earlier in beforeFactory/afterFactory events (setting pgv) and in onPrepare/onRender events (getting pgv) of a label to show the time-taken-for-report-generation, but it gave null. The afterFactory or label-events were probably a wrong place for reading latest pgv value. Guidance on that would also help.

mwilliams

You could possibly group your table on row["manager_id"] + "-" + row["manager_name"], which would generate the same grouping, then in your chart script, you could simply remove the '-' and everything before it, from the label. Just another idea.

As for timing your report, why not use java.io and write a time stamp out to a text file in the initialize then in the afterfactory or afterrender and then you'd know the time. You could log times for any section of the report you'd like with this.