Want one chart instead of many for chart w/Optional Y-series

I have created a bar chart in BIRT that has:
Category (X) Series
Value (Y) Series
Optional Y Series Grouping
 
The bar chart renders just fine, although not in the way I want it to. The report renders 3 different bar charts, one for each value in the Optional Y Series Grouping. (see attachment: not_how_i_want_it.png) (NOTE: generated by BIRT)
 
I would like it to render a single bar chart, with the values from the Category (X) Series' bars grouped inside of the Optional (Y) series grouping. (see attachment: how_i_want_it.png) (NOTE: this image was generated by a tool that is not BIRT).
 
See attachments for examples.

Find more posts tagged with

Comments

pricher

Hi,
 
If it's creating more than one chart, it's more likely because you have put the chart inside the header or footer area of a table grouped on unit.
 
Try creating the chart by itself. Based on your screenshot:
Category-X Series = what looks like a machine name,
Value-Y Series = activity
Y-Series grouping = Hour
 
Hope this helps,
 
P.

sbarkdull

Thank you for your response, let me clarify: 
 
Category-X Series = the time of day (in 0-23 hours) of an "activity"
Value-Y Series = the count of "activities"
Y-Series grouping = machine name (aka Unit)
 
The report currently generated by BIRT is creating separate chart for each Unit. I would like it to create one chart with the "time of the activities" for each unit, grouped by unit, along the x-axis of the chart.
 
Attached is a screen shot of the report designer. It hopefully demonstrates that I have placed the chart in the correct location. BIRT is creating a bar chart for each unit. To give you a sense of how things are grouped, here is an approximation of the sql query:
 
select
 to_char(e.evt_tim::timestamp - interval '5 hour', 'HH24') as time,
 count(e.evt_seq) as event_count, -- aka activity count
 u.unt_id
from
 event e join unit u on e.unit_id = u.id
where
 e.evt_time >= Timestamp '2015-03-08 05:00:00'
 and e.evt_time < Timestamp '2015-03-09 05:00:00'
group by
 u.unt_id, time

pricher

Hi,
 
The screenshot you posted is exactly the behavior I described in my previous post. By putting the chart in the header area of of your grouping (by unit_id), you will get one chart per unit_id. If you want to group the Y-Series by unit_id, you need to put the chart outside of any header of footer area for the group. The easiest way would be to create the chart by itself, outside the table.
 
Take a look at the attached design. It shows the behavior of creating the chart by itself (chart on the left side) vs. placing the chart inside the group header section. Keep in mind that the two charts are designed exactly the same way, with Y-Series grouping.
 
Hope this helps,
 
P.

sbarkdull

Perfect!
This is exactly what I needed, thank you.