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

Stacked bar chart inside group list

Jevo

Hello all. 
 
I have this dataset with three columns: date, zone and count, that is the number of cards per zone in each date. This is a excerpt of my data: 
 
<blockquote class='ipsBlockquote' >Date Zone Count

2007-09-06 Acabador 205 
2007-09-06 Bobinadoras 86 
2007-09-06 Hornos 132 
2007-09-06 Reversible 73 
2007-09-06 Servicios comunes 1 
2007-09-11 Bobinadoras 26 
2007-09-11 Reversible 36 
2007-09-17 Acabador 162 
2007-09-17 Bobinadoras 68 
2007-09-17 Hornos 65 
.... 
.... 
 
And so on...</blockquote>
 
I want to display a stacked bar chart group by date where each column has stacked the number of cards per zone. What I have done in the chart editor is: 
 
* Category (X) series --> Date 
* Value (Y) Series 1 --> Count 
* Optional Y Series grouping --> Zone
 
and the result is the attached image. All right but the problem is that there are many data missed, so birt just displays a set of dates. 
 
My question is, how can I split the chart so that all data be displayed? 
 
I tried to drop a group list and grouping on row.__rownum with a fixed interval of 20. Then I drop my chart in the group header, but if I do that then I cannot use Zone as an optional Y series grouping. 
 
Any idea? 
 
I am using Birt 2.6.1 
 
Thanks in advance.

Find more posts tagged with

Comments

thuston

Set the XAxis to be a Category Axis (on the Format tab).

How detailed does your data need to be?
You could group the dates (on the Select Data tab) by year, or quarter, or month

Jevo

Hi! Thank you for the reply. 
 
<blockquote class='ipsBlockquote' >Set the XAxis to be a Category Axis (on the Format tab).</blockquote>
The X-Axis is already set as a Category Axis, besides it is checked and I cannot unchecked it. 
 
An important thing I didn't mention was that select data inherits data from container (in the Select Data tab), that is the list group. 
 
<blockquote class='ipsBlockquote' >How detailed does your data need to be?</blockquote>
I need to show all my data, that is, the graph should display each date in X-axis. For that reason I need something like the chartSplit.png attached file. The attached file display just the count for each date, since I cannot set Zone as "optional y series grouping" if the chart select data inherits data from the list group. 
 
<blockquote class='ipsBlockquote' >You could group the dates (on the Select Data tab) by year, or quarter, or month</blockquote>
How could I do that? This would show all data? I guess it wouldnt.

thuston

If you need to see each date and you can't make the Chart wider, the only option left is multiple charts in your output.

I would create a Table with some logical grouping that works for you (year? quarter? Zone?).
Then put your Chart in the Group's Header row.
That way you get one output chart for each group.

Jevo

Thanks for you help, Thuston

This is what I am going to try. Now I have to think of the way of grouping. Maybe per year as you suggested. If I success I will let you know.