ichart multiple y axes

[Former Member]

Hello gurus,

I have read the "multiple y axis on charts in sap xmii " discussion and still can not get my chart work .  I have

at the  Y axis tab :

1)  checked the multiple y axes checkbox and

at the Data series detail tab:

2) set the minimun and maximun range from 0 to 100

3) Checked the Show Y axis and Show Y axis label

at the data mapping I have a query with four columns :

Column 1 : Refinery ( set as a x - axis label column )

Column 2 : Gas imported ( set as the first value column )

Column 3 : Gas planned ( set as the second value column )

Column 4 : [ Column 2 / Column 3 ] * 100 ( set as porcentaje at the third value column )

What I get at the chart is only the column 2 and column2 plotted correctly with a left Y axis .  But I need to get the porcentaje values plotted against a right Y axis .

Please help

[Former Member · Accepted solution]

what is your chart type, is it bar chart?

Can you paste a sample image here, how you need a chart?

[Former Member · Accepted solution]

thanks,

It is a custom chart type .  I am sending an image of what the ichart should look like . 

Thanks again & best regards,

[Former Member · Accepted solution]

I hope you getting left and right y axes?

Well in data series you need to provide 3 pen details i.e data series ID ,

Data series ID 1 should be bar, select type as bar

Data series ID 2 should be bar,select type as bar 

Data series ID 3 should be line, select type as line

In chart area increase the marker size and select marker style as circle.

[Former Member · Accepted solution]

thanks,

Indeed, I have provided thre pens as you have suggested but still do not get the right axe ( percentage )  , just the left one .

best regards,

[Former Member · Accepted solution]

I got the output Fernando ,when I tried, see this is sample data and graph I got. I hope you wanted this way?

Dont pass labels, in data mapping instead you can use custom label in x axis,

[Former Member · Accepted solution]

Thanks Padma

Yes that is what I want .  At the X axis ,  I want the column 1 values  ( NombreCentro node from my xml test file ) to be shown .  Or for simplicity,  just add a column to your sample data . It could be 5 cities ,  cars,  whatever .  Can you send the code or how you did it ? . 

Best regards,

[Former Member · Accepted solution]

Fernando, I can share this sample xml and ichart display template for what I did, you can refer and do it. I don't know how can I access your email to send code.

I Provided another column for x axis label, which was first 5 months.  It works.

[Former Member · Accepted solution]

very good demonstration .  My email is antonio.rodriguez@pemex.com .  I would appreciate very much the code . 

[Former Member · Accepted solution]

Fernando,

I had sent you. Hope it helps you.

Good luck .

[Former Member · Accepted solution]

Thanks Padma ,  your help was great .  Best regards,

[jcgood25]

Column 4 is a bit confusing - is the formula just for reference purposes or is that actually coming back in the query results instead of a normal column name or alias?

Perhaps consider sharing a simple upload of the xml test dataset from your query.  If you have multiple ValueColumns mapped into your display template then you should see each of them in the iChart legend, and the default behavior would be for the Y-Axis color and scale to change when selecting one of the items in the legend.  The multiple Y-Axis is more or less just a visual display change, so assuming Columns 2, 3, and 4 are all valid numeric fields with plain text column headings, then mapping them into the chart and having them render should be as simple as you would expect.

Regards,

Jeremy

Rapid Innovation Group (RIG)

[Former Member]

Column 4 is the result of  ( column2 / column 3  ) * 100 . It is a percentaje so its range is from 0 to 100 . I am using a custom chart type .   I am not using the ichart as an applet, instead I am using it as a graphic inserted in a irpt file .

Following is the query xml test dataset :

<?xml version="1.0" encoding="UTF-8" ?> 

- <Rowsets CachedTime="" DateCreated="2013-10-01T11:05:36" EndDate="2012-04-30T00:00:00" StartDate="2012-04-01T00:00:00" Version="12.2.4 Build(80)">

- <Rowset>

- <Columns>

<Column Description="NombreCentro" MaxRange="1" MinRange="0" Name="NombreCentro" SQLDataType="12" SourceColumn="NombreCentro" />

<Column Description="TotalImportado" MaxRange="1" MinRange="0" Name="TotalImportado" SQLDataType="8" SourceColumn="TotalImportado" />

<Column Description="TotalProgramado" MaxRange="1" MinRange="0" Name="TotalProgramado" SQLDataType="8" SourceColumn="TotalProgramado" />

<Column Description="Porcentaje" MaxRange="1" MinRange="0" Name="Porcentaje" SQLDataType="8" SourceColumn="Porcentaje" />

</Columns>

- <Row>

<NombreCentro>0967</NombreCentro>

<TotalImportado>7944113</TotalImportado>

<TotalProgramado>8738524.3</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>0964</NombreCentro>

<TotalImportado>17572170</TotalImportado>

<TotalProgramado>19329386.999999996</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>0966</NombreCentro>

<TotalImportado>1894146</TotalImportado>

<TotalProgramado>2083560.6</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>0968</NombreCentro>

<TotalImportado>368661</TotalImportado>

<TotalProgramado>405527.1000000001</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>0969</NombreCentro>

<TotalImportado>4181507</TotalImportado>

<TotalProgramado>4599657.7</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>0980</NombreCentro>

<TotalImportado>8417.655999999999</TotalImportado>

<TotalProgramado>9259.4216</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>0988</NombreCentro>

<TotalImportado>7733015</TotalImportado>

<TotalProgramado>8506316.5</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>964A</NombreCentro>

<TotalImportado>5308487</TotalImportado>

<TotalProgramado>5839335.7</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

- <Row>

<NombreCentro>970A</NombreCentro>

<TotalImportado>25480.414</TotalImportado>

<TotalProgramado>28028.4554</TotalProgramado>

<Porcentaje>90.909090909091</Porcentaje>

</Row>

</Rowset>

</Rowsets>