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

Incorrect points order

Nikola18

Hi, All. 
 
Can anybody explain to me the reason of incorrect displaying order in my examples? 
I try do scatter char, without category Series grouping and without any aggregated expressions, 
but with Y Series grouping. 
My tested scripted data are nine rows with correct order (0,1,2,3,4,5,6,7,8). 
But, preview shows to me points, connected by lines with bad order (5,6,7,8 and 4,2,0,1,3). 
This attached example named "<a class='bbc_url' href='http://narod.ru/disk/40906057001/workspace.rar.html'>ScatterGroupOnYAxis.rptdesign</a>". 
 
Also, I make an experiment. 
I flipped axis and changed values for category and series. 
The chart became with correct order (5,6,7,8 and 0,1,2,3,4). 
This attached example named "<a class='bbc_url' href='http://narod.ru/disk/40906057001/workspace.rar.html'>ScatterGroupOnYAxisFlip.rptdesign</a>". 
 
Please, help me to do normal order chart without fliping axis. 
 
Thanks.

Find more posts tagged with

Comments

mwilliams

Can you just attach the report design directly into the forum? It allows uploads of .rptdesign type.

Nikola18

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="96277" data-time="1329415303" data-date="16 February 2012 - 11:01 AM">
Can you just attach the report design directly into the forum? It allows uploads of .rptdesign type. </blockquote>
 
ScatterGroupOnYAxis.rptdesign 
 
<pre class='_prettyXprint _lang-auto _linenums:0'><?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.3.v20111028-0207 Build <2.6.3.v20111028-0207></property>
<property name="units">in</property>
<property name="layoutPreference">auto layout</property>
<data-sources>
<script-data-source name="Data Source" id="2"/>
</data-sources>
<data-sets>
<script-data-set name="Data Set" id="3">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">Month</property>
<property name="dataType">any</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Product</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Amount</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ORDNUM</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">Month</property>
</structure>
<structure>
<property name="columnName">Product</property>
</structure>
<structure>
<property name="columnName">Amount</property>
</structure>
<structure>
<property name="columnName">ORDNUM</property>
</structure>
</list-property>
<list-property name="sortHints"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Month</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Product</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Amount</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ORDNUM</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<method name="open"><![CDATA[i = 0;

sourcedata = new Array( new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4));

sourcedata[0][0] = "Jan";
sourcedata[0][1] = 10;
sourcedata[0][2] = 232;
sourcedata[0][3] = 0;

sourcedata[1][0] = "Jan";
sourcedata[1][1] = 20;
sourcedata[1][2] = 291;
sourcedata[1][3] = 1;

sourcedata[2][0] = "Jan";
sourcedata[2][1] = 30;
sourcedata[2][2] = 567;
sourcedata[2][3] = 2;

sourcedata[3][0] = "Jan";
sourcedata[3][1] = 30;
sourcedata[3][2] = 650;
sourcedata[3][3] = 3;

sourcedata[4][0] = "Jan";
sourcedata[4][1] = 25;
sourcedata[4][2] = 700;
sourcedata[4][3] = 4;

sourcedata[5][0] = "Feb";
sourcedata[5][1] = 15;
sourcedata[5][2] = 312;
sourcedata[5][3] = 5;

sourcedata[6][0] = "Feb";
sourcedata[6][1] = 25;
sourcedata[6][2] = 414;
sourcedata[6][3] = 6;

sourcedata[7][0] = "Feb";
sourcedata[7][1] = 30;
sourcedata[7][2] = 512;
sourcedata[7][3] = 7;

sourcedata[8][0] = "Feb";
sourcedata[8][1] = 27;
sourcedata[8][2] = 600;
sourcedata[8][3] = 8;
]]></method>
<method name="fetch"><![CDATA[if ( i < 9 )
{
row["Month"] = sourcedata[i][0];
row["Product"] = sourcedata[i][1];
row["Amount"] = sourcedata[i][2];
row["ORDNUM"] = sourcedata[i][3];

i++;
return true;
}
return false;]]></method>
</script-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="4">
<property name="type">a4</property>
<property name="topMargin">1cm</property>
<property name="leftMargin">1cm</property>
<property name="bottomMargin">1cm</property>
<property name="rightMargin">1cm</property>
<property name="showHeaderOnFirst">false</property>
<property name="showFooterOnLast">false</property>
<property name="headerHeight">0cm</property>
<property name="footerHeight">0cm</property>
<page-header>
<grid id="5">
<property name="width">100%</property>
<column id="6"/>
<row id="7">
<cell id="8">
<property name="fontSize">xx-large</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
</cell>
</row>
</grid>
</page-header>
<page-footer>
<grid id="9">
<property name="width">100%</property>
<column id="10"/>
<column id="11"/>
<row id="12">
<cell id="13">
<text id="14">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</cell>
<cell id="15">
<property name="textAlign">right</property>
</cell>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<extended-item extensionName="Chart" id="76">
<xml-property name="xmlRepresentation"><![CDATA[<ActuateChart version="1.0">
<ChartWithAxes type="Scatter Chart" subType="Standard Scatter Chart" script="j = 0;
dpSize = 0

function afterDataSetFilled( series, dataSet, icsc )
{
var list = dataSet.getValues();
dpSize = list.length;
}

function beforeDrawDataPointLabel( dph, label, icsc )
{
/*
if( dph.getIndex() == dpSize-1 ){
label.setVisible(true);
}else{
label.setVisible(false);
}
*/
label.getCaption().setValue(++j);
//+": "+label.getCaption().getValue()+" :: "+ ((dph.getIndex() == dpSize-1)?"true":"false"));
}

" units="Points">
<block>
<children _type="TitleBlock">
<label>
<caption value="Scatter Chart Title">

<alignment _body="1,"/>

</caption>
</label>
</children>
<children _type="Legend" _id="2">
<text value=""/>
<title>
<caption value=""/>
</title>
</children>
<bounds _body=",,212.0,130.0"/>
</block>
<extendedProperties name="enable.area.alt" value="false"/>
<extendedProperties name="enable.drill.category" value="true"/>
<extendedProperties name="enable.drill.series" value="true"/>
<sampleData>
<baseSampleData dataSetRepresentation="6,4,12,8,10"/>
<orthogonalSampleData dataSetRepresentation="6,4,12,8,10"/>
</sampleData>
<emptyMessage>
<caption value="This chart contains no data.">

<alignment _body="1,"/>

</caption>
</emptyMessage>
<axes type="0" categoryAxis="false">
<title>
<caption value="X-Axis Title">

<alignment _body="1,"/>

</caption>
</title>
<associatedAxes>
<title>
<caption value="Y-Axis Title">

<alignment _body="1,"/>

</caption>
</title>
<seriesDefinitions>
<query definition="row["Month"]">
<grouping/>
</query>
<seriesPalette>
<entries _id="31"/>
</seriesPalette>
<series _type="ScatterSeries" seriesIdentifier="Series 1" paletteLineColor="true">
<label visible="true">
<caption value=""/>
</label>
<dataDefinition definition="row["Amount"]">
<grouping/>
</dataDefinition>
<dataPoint prefix="" suffix="" separator=", "/>
<markers type="3" size="3" visible="true">
<outline/>
</markers>
<lineAttributes visible="true"/>
</series>
<grouping _nil="1"/>
<sortKey/>
</seriesDefinitions>
<lineAttributes>
<color _nil="1"/>
</lineAttributes>
<label>
<caption value=""/>
</label>
</associatedAxes>
<seriesDefinitions>
<query definition=""/>
<seriesPalette>
<entries _id="31"/>
</seriesPalette>
<series seriesIdentifier="">
<label>
<caption value=""/>
</label>
<dataDefinition definition="row["Product"]"/>
<dataPoint separator=", ">
<components type="1"/>
</dataPoint>
</series>
<grouping groupType="0"/>
<sortKey definition="row["Product"]"/>
</seriesDefinitions>
<lineAttributes>
<color _nil="1"/>
</lineAttributes>
<label>
<caption value=""/>
</label>
</axes>
</ChartWithAxes>
</ActuateChart>
]]></xml-property>
<property name="outputFormat">SVG</property>
<property name="inheritColumns">false</property>
<property name="dataSet">Data Set</property>
<property name="height">4.9375in</property>
<property name="width">7.479166666666667in</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Month</property>
<expression name="expression" type="javascript">dataSetRow["Month"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Product</property>
<expression name="expression" type="javascript">dataSetRow["Product"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Amount</property>
<expression name="expression" type="javascript">dataSetRow["Amount"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">ORDNUM</property>
<expression name="expression" type="javascript">dataSetRow["ORDNUM"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
</extended-item>
</body>
</report>
</pre>

mwilliams

I think the difference you're seeing is just a product of your sample data. On your flipped axis sample, go back into the data and make several of the "Amount" field values the same. For example, I make a couple other values 232, so that three were that and I make the 600 into 650. Now when you run the report, it looks out of order like the other one. The issue with your first report is not really solved by the flipped axis, the Amount field just happened to not have duplicate values, like the "Product" field.

Nikola18

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="96277" data-time="1329415303" data-date="16 February 2012 - 11:01 AM">
Can you just attach the report design directly into the forum? It allows uploads of .rptdesign type. </blockquote>
 
ScatterGroupOnYAxisFlip.rptdesign 
 
<pre class='_prettyXprint _lang-auto _linenums:0'><?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.3.v20111028-0207 Build <2.6.3.v20111028-0207></property>
<property name="units">in</property>
<property name="layoutPreference">auto layout</property>
<data-sources>
<script-data-source name="Data Source" id="2"/>
</data-sources>
<data-sets>
<script-data-set name="Data Set" id="3">
<list-property name="resultSetHints">
<structure>
<property name="position">1</property>
<property name="name">Month</property>
<property name="dataType">any</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Product</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Amount</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ORDNUM</property>
<property name="dataType">integer</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">Month</property>
</structure>
<structure>
<property name="columnName">Product</property>
</structure>
<structure>
<property name="columnName">Amount</property>
</structure>
<structure>
<property name="columnName">ORDNUM</property>
</structure>
</list-property>
<list-property name="sortHints"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Month</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Product</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Amount</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ORDNUM</property>
<property name="dataType">integer</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<method name="open"><![CDATA[i = 0;

sourcedata = new Array( new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4),
new Array(4));

sourcedata[0][0] = "Jan";
sourcedata[0][1] = 10;
sourcedata[0][2] = 232;
sourcedata[0][3] = 0;

sourcedata[1][0] = "Jan";
sourcedata[1][1] = 20;
sourcedata[1][2] = 291;
sourcedata[1][3] = 1;

sourcedata[2][0] = "Jan";
sourcedata[2][1] = 30;
sourcedata[2][2] = 567;
sourcedata[2][3] = 2;

sourcedata[3][0] = "Jan";
sourcedata[3][1] = 30;
sourcedata[3][2] = 650;
sourcedata[3][3] = 3;

sourcedata[4][0] = "Jan";
sourcedata[4][1] = 25;
sourcedata[4][2] = 700;
sourcedata[4][3] = 4;

sourcedata[5][0] = "Feb";
sourcedata[5][1] = 15;
sourcedata[5][2] = 312;
sourcedata[5][3] = 5;

sourcedata[6][0] = "Feb";
sourcedata[6][1] = 25;
sourcedata[6][2] = 414;
sourcedata[6][3] = 6;

sourcedata[7][0] = "Feb";
sourcedata[7][1] = 30;
sourcedata[7][2] = 512;
sourcedata[7][3] = 7;

sourcedata[8][0] = "Feb";
sourcedata[8][1] = 27;
sourcedata[8][2] = 600;
sourcedata[8][3] = 8;
]]></method>
<method name="fetch"><![CDATA[if ( i < 9 )
{
row["Month"] = sourcedata[i][0];
row["Product"] = sourcedata[i][1];
row["Amount"] = sourcedata[i][2];
row["ORDNUM"] = sourcedata[i][3];

i++;
return true;
}
return false;]]></method>
</script-data-set>
</data-sets>
<page-setup>
<simple-master-page name="Simple MasterPage" id="4">
<property name="type">a4</property>
<property name="topMargin">1cm</property>
<property name="leftMargin">1cm</property>
<property name="bottomMargin">1cm</property>
<property name="rightMargin">1cm</property>
<property name="showHeaderOnFirst">false</property>
<property name="showFooterOnLast">false</property>
<property name="headerHeight">0cm</property>
<property name="footerHeight">0cm</property>
<page-header>
<grid id="5">
<property name="width">100%</property>
<column id="6"/>
<row id="7">
<cell id="8">
<property name="fontSize">xx-large</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
</cell>
</row>
</grid>
</page-header>
<page-footer>
<grid id="9">
<property name="width">100%</property>
<column id="10"/>
<column id="11"/>
<row id="12">
<cell id="13">
<text id="14">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</cell>
<cell id="15">
<property name="textAlign">right</property>
</cell>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<extended-item extensionName="Chart" id="76">
<xml-property name="xmlRepresentation"><![CDATA[<ActuateChart version="1.0">
<ChartWithAxes type="Scatter Chart" subType="Standard Scatter Chart" script="j = 0;
dpSize = 0

function afterDataSetFilled( series, dataSet, icsc )
{
var list = dataSet.getValues();
dpSize = list.length;
}

function beforeDrawDataPointLabel( dph, label, icsc )
{
/*
if( dph.getIndex() == dpSize-1 ){
label.setVisible(true);
}else{
label.setVisible(false);
}
*/
label.getCaption().setValue(++j);
//+": "+label.getCaption().getValue()+" :: "+ ((dph.getIndex() == dpSize-1)?"true":"false"));
}

" units="Points" orientation="0">
<block>
<children _type="TitleBlock">
<label>
<caption value="Scatter Chart Title">

<alignment _body="1,"/>

</caption>
</label>
</children>
<children _type="Legend" _id="2">
<text value=""/>
<title>
<caption value=""/>
</title>
</children>
<bounds _body=",,212.0,130.0"/>
</block>
<extendedProperties name="enable.area.alt" value="false"/>
<extendedProperties name="enable.drill.category" value="true"/>
<extendedProperties name="enable.drill.series" value="true"/>
<sampleData>
<baseSampleData dataSetRepresentation="6,4,12,8,10"/>
<orthogonalSampleData dataSetRepresentation="6,4,12,8,10"/>
</sampleData>
<emptyMessage>
<caption value="This chart contains no data.">

<alignment _body="1,"/>

</caption>
</emptyMessage>
<axes type="0" categoryAxis="false">
<title>
<caption value="X-Axis Title">

<alignment _body="1,"/>

</caption>
</title>
<associatedAxes>
<title>
<caption value="Y-Axis Title">

<alignment _body="1,"/>

</caption>
</title>
<seriesDefinitions>
<query definition="row["Month"]">
<grouping/>
</query>
<seriesPalette>
<entries _id="31"/>
</seriesPalette>
<series _type="ScatterSeries" seriesIdentifier="Series 1" paletteLineColor="true">
<label visible="true">
<caption value=""/>
</label>
<dataDefinition definition="row["Product"]">
<grouping/>
</dataDefinition>
<dataPoint prefix="" suffix="" separator=", "/>
<markers type="3" size="3" visible="true">
<outline/>
</markers>
<lineAttributes visible="true"/>
</series>
<sortKey/>
</seriesDefinitions>
<lineAttributes>
<color _nil="1"/>
</lineAttributes>
<label>
<caption value=""/>
</label>
</associatedAxes>
<seriesDefinitions>
<query definition=""/>
<seriesPalette>
<entries _id="31"/>
</seriesPalette>
<series seriesIdentifier="">
<label>
<caption value=""/>
</label>
<dataDefinition definition="row["Amount"]"/>
<dataPoint separator=", ">
<components type="1"/>
</dataPoint>
</series>
<grouping groupType="0"/>
<sortKey definition="row["Amount"]"/>
</seriesDefinitions>
<lineAttributes>
<color _nil="1"/>
</lineAttributes>
<label>
<caption value=""/>
</label>
</axes>
</ChartWithAxes>
</ActuateChart>
]]></xml-property>
<property name="outputFormat">SVG</property>
<property name="inheritColumns">false</property>
<property name="dataSet">Data Set</property>
<property name="height">4.9375in</property>
<property name="width">7.479166666666667in</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">Month</property>
<expression name="expression" type="javascript">dataSetRow["Month"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Product</property>
<expression name="expression" type="javascript">dataSetRow["Product"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">Amount</property>
<expression name="expression" type="javascript">dataSetRow["Amount"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">ORDNUM</property>
<expression name="expression" type="javascript">dataSetRow["ORDNUM"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
</extended-item>
</body>
</report>
</pre>

mwilliams

In between your two posts of your xml source, you'll see the explanation for why you're seeing what you're seeing. In case you didn't see that.

Nikola18

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="96281" data-time="1329419107" data-date="16 February 2012 - 12:05 PM">
I think the difference you're seeing is just a product of your sample data. On your flipped axis sample, go back into the data and make several of the "Amount" field values the same. For example, I make a couple other values 232, so that three were that and I make the 600 into 650. Now when you run the report, it looks out of order like the other one. The issue with your first report is not really solved by the flipped axis, the Amount field just happened to not have duplicate values, like the "Product" field. </blockquote>
 
You are right! 
I tested a different sets of data and I got both good, and bad results. 
So, question: is it correct functioning of the Actuate BIRT? 
 
If I do not specify the order, I wait this order should be as in dataset rows?! 
Am I right?

mwilliams

I have been trying to reproduce this order with different groupings in a table, unsuccessfully. I'm not sure where this order comes in. You could try filing a bug for this and seeing what they say. But, they'll probably just say to sort the x-axis in ascending order by your product field.

Nikola18

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="96359" data-time="1329512798" data-date="17 February 2012 - 02:06 PM">
I have been trying to reproduce this order with different groupings in a table, unsuccessfully. I'm not sure where this order comes in. You could try filing a bug for this and seeing what they say. But, they'll probably just say to sort the x-axis in ascending order by your product field. </blockquote>
 
I posted like a <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=372016'>bag #372016</a>.

mwilliams

Thanks for the update!