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

Multiple series chart in birt

Namchinbum Ganbat

Dears
actually I am a new on birt report designer, i am trying to create a chart with multiple chart, but since dont have mutiple x-axis, i cannot count 2nd series correctly,
 
pls help me to do this

Find more posts tagged with

Comments

sureshpulapalli

Hi,
 
why do you need multiple x-axis? I don't see anything wrong in the attached screen shots. It would be great if you can provide more details regarding your requirement
 
 
 
Regards,
Suresh

Namchinbum Ganbat

<blockquote class="ipsBlockquote" data-author="sureshpulapalli" data-cid="146725" data-time="1486021165">
<div>
Hi,
 
why do you need multiple x-axis? I don't see anything wrong in the attached screen shots. It would be great if you can provide more details regarding your requirement
 
 
 
Regards,
Suresh
</div>
</blockquote>
Hi,
 
if i create a chart with 2 separate chart for actual_month and report_month etc, it shows correct result,
but after combning them into one chart , all the months for 2nd series are sames as 1st series, i think it is for 2nd series, value is report_month row and x-axis is actual_month

Namchinbum Ganbat

Pls see the attached

sureshpulapalli

can you please send me your report design?

Namchinbum Ganbat

pls see the design file as attached

Clement Wong

Your data should be re-organized. Currently, it looks like this?
<pre class="_prettyXprint">
Actual_Months Reported_Months
1 1
2 3
3 4
5 5</pre>
Since you are using the Actual_Months as the X-Axis, you're going to miss the values for Reported_Months = 2. Now, if you use Reported_Months in the X-Axis, you are going to miss the values for Actual_Months = 4.
 
Are you able to change your SQL so that it will return the following so that all months are part of the output?
<pre class="_prettyXprint _lang-">
Month Actual_Months Reported_Months
1 1 1
2 1 0
3 0 1
4 1 0
5 1 2
</pre>
 Then, you can use the first column (Month) as the X-Axis.
 
Series 1: SUM of Actual_Months
Series 2: SUM of Reported_Months

Namchinbum Ganbat

<blockquote class="ipsBlockquote" data-author="Clement Wong" data-cid="146763" data-time="1486515665">
<div>
Your data should be re-organized. Currently, it looks like this?
<pre class="_prettyXprint">
Actual_Months Reported_Months
1 1
2 3
3 4
5 5</pre>
Since you are using the Actual_Months as the X-Axis, you're going to miss the values for Reported_Months = 2. Now, if you use Reported_Months in the X-Axis, you are going to miss the values for Actual_Months = 4.
 
Are you able to change your SQL so that it will return the following so that all months are part of the output?
<pre class="_prettyXprint _lang-">
Month Actual_Months Reported_Months
1 1 1
2 1 0
3 0 1
4 1 0
5 1 2
</pre>
 Then, you can use the first column (Month) as the X-Axis.
 
Series 1: SUM of Actual_Months
Series 2: SUM of Reported_Months
</div>
</blockquote>
Hi Wong
actually i cannot join those 2 results . because both include aggregation function.

Clement Wong

Are you able to use UNION in your SQL statement?

Namchinbum Ganbat

already did. thanks dear a lot