FixedCrossTable class: Difference between revisions
More actions
No edit summary  | 
				No edit summary  | 
				||
| Line 1: | Line 1: | ||
<parsererror style="display: block; white-space: pre; border: 2px solid #c77; padding: 0 1em 0 1em; margin: 1em; background-color: #fdd; color: black">  | |||
=== This page contains the following errors: ===  | |||
<div style="font-family:monospace;font-size:12px">error on line 1 at column 9751: Opening and ending tag mismatch: source line 0 and p </div>  | |||
=== Below is a rendering of the page up to the first error. ===  | |||
</parsererror>  | |||
{{CGscriptClass_Template |Name=FixedCrossTable |Description=A resource journal entry |Constructors= {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 1x0 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 2x0 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 1x1 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryColAxis|Description=Axis from Axis_xxx function for the secondary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 1x2 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 2x1 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryColAxis|Description=Axis from Axis_xxx function for the secondary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 2x2 FixedCrossTable.}} |Methods= {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}} |Properties= {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}} {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=TypeInformation|HasGetter=1|Description=Get information about this class.}} }} === Examples For Table 1x0 === <source lang="javascript">DCS_use(12344983); // Get Axis: array axisNew = Axis_new("LuuTest"); axisNew[AXIS_TEXT] = "Choose a D_Week"; // Init: FixedCrossTableRowSeries rowseries = new FixedCrossTableRowSeries(); FixedCrossTableDataSeries dataserie= new FixedCrossTableDataSeries(); FixedCrossTableDataItem dataItemAbs= new FixedCrossTableDataItem(); FixedCrossTableDataItem dataItemPct= new FixedCrossTableDataItem(); // Set up a table // table 1x0 Axis_addOption(axisNew, AxisOption_new("Week 1", "")); Axis_addOption(axisNew, AxisOption_new("Week 2", "")); dataItemAbs.Value = 1; dataItemPct.Value = 50; dataserie.Add(dataItemAbs,dataItemPct); dataserie.Add(dataItemAbs,dataItemPct); dataserie.AbsoluteTotal.Value = 2; dataserie.PercentageTotal.Value = 100; rowseries.Add(dataserie); FixedCrossTable table1x0 = new FixedCrossTable("Create by createFixedCrossDiagram - D_Week", axisNew , rowseries, empty); // genarate table: createFixedCrossDiagram(table1x0); Result: <br/>[[File:Tabu Table1x0.png]] === Examples For Table 1x1 === <source lang="javascript">DCS_use(15517112); // Get Axis: array axisPrimary = Axis_new("LuuTest1"); axisPrimary[AXIS_TEXT] = "Choose a D_Week"; array axisSecond = Axis_new("LuuTest2"); axisSecond[AXIS_TEXT] = "Choose a Region"; Axis_addOption(axisPrimary, AxisOption_new("Year 2014", "")); Axis_addOption(axisPrimary, AxisOption_new("Other Year", "")); Axis_addOption(axisSecond, AxisOption_new("Male", "")); Axis_addOption(axisSecond, AxisOption_new("Female", "")); // Init: array arrRowseries ={}; number countTotal = count() where true; number count; FixedCrossTableRowSeries rowseries; FixedCrossTableDataItem dataItemAbs; FixedCrossTableDataItem dataItemPct; FixedCrossTableDataSeries dataserie; dataserie = new FixedCrossTableDataSeries(); count = count() where D_Week == [201401-201453] && Gender == [1]; dataItemAbs = new FixedCrossTableDataItem(); dataItemAbs.Value = count; dataItemPct = new FixedCrossTableDataItem(); dataItemPct.Value = count*100/countTotal; dataserie.Add(dataItemAbs,dataItemPct); count = count() where D_Week == [201401-201453] && Gender == [2]; dataItemAbs = new FixedCrossTableDataItem(); dataItemAbs.Value = count; dataItemPct = new FixedCrossTableDataItem(); dataItemPct.Value = count*100/countTotal; dataserie.Add(dataItemAbs,dataItemPct); count = count() where D_Week == [201401-201453]; dataserie.AbsoluteTotal.Value = count; dataserie.PercentageTotal.Value = count/count * 100; rowseries.Add(dataserie); arrRowseries = {rowseries,rowseries,rowseries}; // Set up a table // table 1x1 FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty); // genarate table: createFixedCrossDiagram(table1x1); Result: <br/>[[File:Tabu Table1x1.png]] === Examples For Table 2x1 === <source lang="javascript">DCS_use(15517112); // Get Axis: array axisRowPrimary = Axis_new("LuuTest1"); axisRowPrimary[AXIS_TEXT] = "Gender test"; Axis_addOption(axisRowPrimary, AxisOption_new("Mand", "")); Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", "")); array axisRowSecond = Axis_new("LuuTest2"); axisRowSecond[AXIS_TEXT] = "Region test"; Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", "")); Axis_addOption(axisRowSecond, AxisOption_new("Other Region", "")); array axisColPrimary = Axis_new("LuuTest3"); axisColPrimary[AXIS_TEXT] = "Week test"; Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", "")); Axis_addOption(axisColPrimary, AxisOption_new("Year Other", "")); array arrRowseries ={}; number count; FixedCrossTableRowSeries rowseries; FixedCrossTableDataItem dataItemAbs; FixedCrossTableDataSeries dataserie; dataserie = new FixedCrossTableDataSeries(); dataItemAbs = new FixedCrossTableDataItem(); dataItemAbs.Value = 1; dataserie.Add(dataItemAbs,dataItemAbs); dataserie.Add(dataItemAbs,dataItemAbs); dataserie.AbsoluteTotal.Value = 1; dataserie.PercentageTotal.Value = 1; rowseries.Add(dataserie); rowseries.Add(dataserie); arrRowseries = {rowseries,rowseries,rowseries}; FixedCrossTable table2x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, arrRowseries, empty); // genarate table: createFixedCrossDiagram(table2x1); createCrossDiagram({"Gender","Region"},{"D_Week"}); Result: <br/>[[File:Tabu Table1x1.png]]<br/><br/></source></source></source>  | |||
|  | |||
|  | |||
|  | |||
|  | |||
|  | |||
|  | |||
|  | |||
===   | |||
dataserie  | |||
==  | |||
//   | |||
Axis_addOption(  | |||
Axis_addOption(axisSecond, AxisOption_new("  | |||
number countTotal = count() where true;  | |||
number count;  | |||
FixedCrossTableRowSeries rowseries;  | |||
FixedCrossTableDataItem dataItemAbs;  | |||
FixedCrossTableDataItem dataItemPct;  | |||
FixedCrossTableDataSeries dataserie;  | |||
dataserie = new FixedCrossTableDataSeries();  | |||
count = count() where D_Week == [201401-201453] && Gender == [1];  | |||
dataItemAbs = new FixedCrossTableDataItem();  | |||
dataItemAbs.Value = count;  | |||
dataItemPct = new FixedCrossTableDataItem();  | |||
dataItemPct.Value = count*100/countTotal;  | |||
dataserie.Add(dataItemAbs,dataItemPct);  | |||
count = count() where D_Week == [201401-201453] && Gender == [2];  | |||
dataItemAbs = new FixedCrossTableDataItem();  | |||
dataItemAbs.Value = count;  | |||
dataItemPct = new FixedCrossTableDataItem();  | |||
dataItemPct.Value = count*100/countTotal;  | |||
dataserie.Add(dataItemAbs,dataItemPct);  | |||
count = count() where D_Week == [201401-201453];  | |||
dataserie.AbsoluteTotal.Value = count;  | |||
dataserie.PercentageTotal.Value = count/count * 100;  | |||
rowseries.Add(dataserie);  | |||
arrRowseries = {rowseries,rowseries,rowseries};  | |||
// Set up a table  | |||
// table 1x1  | |||
FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty);  | |||
// genarate table:  | |||
createFixedCrossDiagram(table1x1);  | |||
<br/>  | |||
=== Examples ===  | |||
DCS_use(15517112);  | |||
// Get Axis:  | |||
array axisRowPrimary = Axis_new("LuuTest1");  | |||
axisRowPrimary[AXIS_TEXT] = "Gender test";  | |||
Axis_addOption(axisRowPrimary, AxisOption_new("Mand", ""));  | |||
Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", ""));  | |||
array axisRowSecond = Axis_new("LuuTest2");  | |||
axisRowSecond[AXIS_TEXT] = "Region test";  | |||
Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", ""));  | |||
Axis_addOption(axisRowSecond, AxisOption_new("Other Region", ""));  | |||
array axisColPrimary = Axis_new("LuuTest3");  | |||
axisColPrimary[AXIS_TEXT] = "Week test";  | |||
Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", ""));  | |||
Axis_addOption(axisColPrimary, AxisOption_new("Year Other", ""));  | |||
array arrRowseries ={};  | |||
number count;  | |||
FixedCrossTableRowSeries rowseries;  | |||
FixedCrossTableDataItem dataItemAbs;  | |||
FixedCrossTableDataSeries dataserie;  | |||
dataserie = new FixedCrossTableDataSeries();  | |||
dataItemAbs = new FixedCrossTableDataItem();  | |||
dataItemAbs.Value = 1;  | |||
dataserie.Add(dataItemAbs,dataItemAbs);  | |||
dataserie.Add(dataItemAbs,dataItemAbs);  | |||
dataserie.AbsoluteTotal.Value = 1;  | |||
dataserie.PercentageTotal.Value = 1;  | |||
rowseries.Add(dataserie);  | |||
rowseries.Add(dataserie);  | |||
arrRowseries = {rowseries,rowseries,rowseries};  | |||
FixedCrossTable table2x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, arrRowseries, empty);  | |||
// genarate table:  | |||
createFixedCrossDiagram(table2x1);  | |||
createCrossDiagram({"Gender","Region"},{"D_Week"});  | |||
</source>  | |||
Revision as of 06:40, 7 December 2015
<parsererror style="display: block; white-space: pre; border: 2px solid #c77; padding: 0 1em 0 1em; margin: 1em; background-color: #fdd; color: black">
This page contains the following errors:
Below is a rendering of the page up to the first error.
</parsererror>
{{CGscriptClass_Template |Name=FixedCrossTable |Description=A resource journal entry |Constructors= {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 1x0 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 2x0 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 1x1 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryColAxis|Description=Axis from Axis_xxx function for the secondary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=FixedCrossTableRowSeries|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 1x2 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 2x1 FixedCrossTable.}} {{CGscriptConstructors_Template|Parameters= {{CGscriptParameters_Template|Type=string|Name=rowTitle|Description=Title of row.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryRowAxis|Description=Axis from Axis_xxx function for the primary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryRowAxis|Description=Axis from Axis_xxx function for the secondary row axis.|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=colTitle|Description=Title of column.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=primaryColAxis|Description=Axis from Axis_xxx function for the primary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=secondaryColAxis|Description=Axis from Axis_xxx function for the secondary column axis.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=rowSeries|Description=Data for the table.|Comma=,}}{{CGscriptParameters_Template|Type=array|Name=statisticsValues|Description=Array of StatisticsItems.}} |Description=Create new 2x2 FixedCrossTable.}} |Methods= {{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}} |Properties= {{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}} {{CGscriptProperties_Template|ReturnType=TypeInformation|Name=TypeInformation|HasGetter=1|Description=Get information about this class.}} }} === Examples For Table 1x0 ===
DCS_use(12344983); // Get Axis: array axisNew = Axis_new("LuuTest"); axisNew[AXIS_TEXT] = "Choose a D_Week"; // Init: FixedCrossTableRowSeries rowseries = new FixedCrossTableRowSeries(); FixedCrossTableDataSeries dataserie= new FixedCrossTableDataSeries(); FixedCrossTableDataItem dataItemAbs= new FixedCrossTableDataItem(); FixedCrossTableDataItem dataItemPct= new FixedCrossTableDataItem(); // Set up a table // table 1x0 Axis_addOption(axisNew, AxisOption_new("Week 1", "")); Axis_addOption(axisNew, AxisOption_new("Week 2", "")); dataItemAbs.Value = 1; dataItemPct.Value = 50; dataserie.Add(dataItemAbs,dataItemPct); dataserie.Add(dataItemAbs,dataItemPct); dataserie.AbsoluteTotal.Value = 2; dataserie.PercentageTotal.Value = 100; rowseries.Add(dataserie); FixedCrossTable table1x0 = new FixedCrossTable("Create by createFixedCrossDiagram - D_Week", axisNew , rowseries, empty); // genarate table: createFixedCrossDiagram(table1x0); Result: <br/>[[File:Tabu Table1x0.png]] === Examples For Table 1x1 === <source lang="javascript">DCS_use(15517112); // Get Axis: array axisPrimary = Axis_new("LuuTest1"); axisPrimary[AXIS_TEXT] = "Choose a D_Week"; array axisSecond = Axis_new("LuuTest2"); axisSecond[AXIS_TEXT] = "Choose a Region"; Axis_addOption(axisPrimary, AxisOption_new("Year 2014", "")); Axis_addOption(axisPrimary, AxisOption_new("Other Year", "")); Axis_addOption(axisSecond, AxisOption_new("Male", "")); Axis_addOption(axisSecond, AxisOption_new("Female", "")); // Init: array arrRowseries ={}; number countTotal = count() where true; number count; FixedCrossTableRowSeries rowseries; FixedCrossTableDataItem dataItemAbs; FixedCrossTableDataItem dataItemPct; FixedCrossTableDataSeries dataserie; dataserie = new FixedCrossTableDataSeries(); count = count() where D_Week == [201401-201453] && Gender == [1]; dataItemAbs = new FixedCrossTableDataItem(); dataItemAbs.Value = count; dataItemPct = new FixedCrossTableDataItem(); dataItemPct.Value = count*100/countTotal; dataserie.Add(dataItemAbs,dataItemPct); count = count() where D_Week == [201401-201453] && Gender == [2]; dataItemAbs = new FixedCrossTableDataItem(); dataItemAbs.Value = count; dataItemPct = new FixedCrossTableDataItem(); dataItemPct.Value = count*100/countTotal; dataserie.Add(dataItemAbs,dataItemPct); count = count() where D_Week == [201401-201453]; dataserie.AbsoluteTotal.Value = count; dataserie.PercentageTotal.Value = count/count * 100; rowseries.Add(dataserie); arrRowseries = {rowseries,rowseries,rowseries}; // Set up a table // table 1x1 FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty); // genarate table: createFixedCrossDiagram(table1x1); Result: <br/>[[File:Tabu Table1x1.png]] === Examples For Table 2x1 === <source lang="javascript">DCS_use(15517112); // Get Axis: array axisRowPrimary = Axis_new("LuuTest1"); axisRowPrimary[AXIS_TEXT] = "Gender test"; Axis_addOption(axisRowPrimary, AxisOption_new("Mand", "")); Axis_addOption(axisRowPrimary, AxisOption_new("Kvinde", "")); array axisRowSecond = Axis_new("LuuTest2"); axisRowSecond[AXIS_TEXT] = "Region test"; Axis_addOption(axisRowSecond, AxisOption_new("Region Hovedstaden", "")); Axis_addOption(axisRowSecond, AxisOption_new("Other Region", "")); array axisColPrimary = Axis_new("LuuTest3"); axisColPrimary[AXIS_TEXT] = "Week test"; Axis_addOption(axisColPrimary, AxisOption_new("Year 2014", "")); Axis_addOption(axisColPrimary, AxisOption_new("Year Other", "")); array arrRowseries ={}; number count; FixedCrossTableRowSeries rowseries; FixedCrossTableDataItem dataItemAbs; FixedCrossTableDataSeries dataserie; dataserie = new FixedCrossTableDataSeries(); dataItemAbs = new FixedCrossTableDataItem(); dataItemAbs.Value = 1; dataserie.Add(dataItemAbs,dataItemAbs); dataserie.Add(dataItemAbs,dataItemAbs); dataserie.AbsoluteTotal.Value = 1; dataserie.PercentageTotal.Value = 1; rowseries.Add(dataserie); rowseries.Add(dataserie); arrRowseries = {rowseries,rowseries,rowseries}; FixedCrossTable table2x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisRowPrimary, axisRowSecond,"Column title", axisColPrimary, arrRowseries, empty); // genarate table: createFixedCrossDiagram(table2x1); createCrossDiagram({"Gender","Region"},{"D_Week"}); Result: <br/>[[File:Tabu Table1x1.png]]<br/><br/>
</source></source>