CreateFixedCrossDiagram - Revision history

Administrator at 05:17, 22 April 2022

2022-04-22T05:17:04Z

← Older revision		Revision as of 05:17, 22 April 2022
Line 71:		Line 71:
	Version 6.0 __NOTOC__		Version 6.0 __NOTOC__
	<!-- imported from file: 4223.htm-->		<!-- imported from file: 4223.htm-->
			[[Category:Diagram/report_generating_CGScript_functions]]

Hovietluu at 02:44, 8 December 2015

2015-12-08T02:44:56Z

@@ Line 19: / Line 19: @@
 '''Examples'''
-{| border="1" cellspacing="0" cellpadding="0" style="width: 1000px"
+<source lang="javascript">
-|-
+DCS_use(15517112);
-| <div>DCS_use(15517112);</div><div>&nbsp;</div><div>// Get Axis:</div><div>array axisPrimary = Axis_new("LuuTest1");</div><div>axisPrimary[AXIS_TEXT] = "Choose a D_Week";</div><div>&nbsp;</div><div>array axisSecond = Axis_new("LuuTest2");</div><div>axisSecond[AXIS_TEXT] = "Choose a Region";</div><div>&nbsp;</div><div>Axis_addOption(axisPrimary, AxisOption_new("Year 2014", ""));</div><div>Axis_addOption(axisPrimary, AxisOption_new("Other Year", ""));</div><div>&nbsp;</div><div>Axis_addOption(axisSecond, AxisOption_new("Male", ""));</div><div>Axis_addOption(axisSecond, AxisOption_new("Female", ""));</div><div>// Init:</div><div>array arrRowseries ={};</div><div>number countTotal = count() where true;</div><div>number count;</div><div>FixedCrossTableRowSeries rowseries;</div><div>FixedCrossTableDataItem dataItemAbs;</div><div>FixedCrossTableDataItem dataItemPct;</div><div>FixedCrossTableDataSeries dataserie;</div><div>&nbsp;</div><div>dataserie = new FixedCrossTableDataSeries();</div><div>count = count() where D_Week == [201401-201453] && Gender == [1];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count*100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div>&nbsp;</div><div>count = count() where D_Week == [201401-201453] && Gender == [2];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count*100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div>&nbsp;</div><div>count = count() where D_Week == [201401-201453];</div><div>dataserie.AbsoluteTotal.Value = count;</div><div>dataserie.PercentageTotal.Value = count/count * 100;</div><div>rowseries.Add(dataserie);</div><div>arrRowseries = {rowseries,rowseries,rowseries};</div><div>// Set up a table</div><div>FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty);</div><div>// genarate table:</div><div>createFixedCrossDiagram(table1x1);</div>
-|}
+// Get Axis:
 '''Availability'''

Hovietluu at 02:19, 8 December 2015

2015-12-08T02:19:27Z

← Older revision		Revision as of 02:19, 8 December 2015
Line 21:		Line 21:
	{\| border="1" cellspacing="0" cellpadding="0" style="width: 1000px"		{\| border="1" cellspacing="0" cellpadding="0" style="width: 1000px"
	\|-		\|-
	\| <div>DCS_use(15517112);</div><div> </div><div>// Get Axis:</div><div>array axisPrimary = Axis_new("LuuTest1");</div><div>axisPrimary[AXIS_TEXT] = "Choose a D_Week";</div><div> </div><div>array axisSecond = Axis_new("LuuTest2");</div><div>axisSecond[AXIS_TEXT] = "Choose a Region";</div><div> </div><div>Axis_addOption(axisPrimary, AxisOption_new("Year 2014", ""));</div><div>Axis_addOption(axisPrimary, AxisOption_new("Other Year", ""));</div><div> </div><div>Axis_addOption(axisSecond, AxisOption_new("Male", ""));</div><div>Axis_addOption(axisSecond, AxisOption_new("Female", ""));</div><div>// Init:</div><div>array arrRowseries ={};</div><div>number countTotal = count() where true;</div><div>number count;</div><div>FixedCrossTableRowSeries rowseries;</div><div>FixedCrossTableDataItem dataItemAbs;</div><div>FixedCrossTableDataItem dataItemPct;</div><div>FixedCrossTableDataSeries dataserie;</div><div> </div><div>dataserie = new FixedCrossTableDataSeries();</div><div>count = count() where D_Week == [201401-201453] && Gender == [1];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div> </div><div>count = count() where D_Week == [201401-201453] && Gender == [2];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div> </div><div>count = count() where D_Week == [201401-201453];</div><div>dataserie.AbsoluteTotal.Value = count;</div><div>dataserie.PercentageTotal.Value = count/count * 100;</div><div>rowseries.Add(dataserie);</div><div>arrRowseries = {rowseries,rowseries,rowseries};</div><div>// Set up a table~~</div><div>// table 2x0</div><div> </div><div> ~~</div><div>FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty);</div><div>// genarate table:</div><div>createFixedCrossDiagram(table1x1);</div>		\| <div>DCS_use(15517112);</div><div> </div><div>// Get Axis:</div><div>array axisPrimary = Axis_new("LuuTest1");</div><div>axisPrimary[AXIS_TEXT] = "Choose a D_Week";</div><div> </div><div>array axisSecond = Axis_new("LuuTest2");</div><div>axisSecond[AXIS_TEXT] = "Choose a Region";</div><div> </div><div>Axis_addOption(axisPrimary, AxisOption_new("Year 2014", ""));</div><div>Axis_addOption(axisPrimary, AxisOption_new("Other Year", ""));</div><div> </div><div>Axis_addOption(axisSecond, AxisOption_new("Male", ""));</div><div>Axis_addOption(axisSecond, AxisOption_new("Female", ""));</div><div>// Init:</div><div>array arrRowseries ={};</div><div>number countTotal = count() where true;</div><div>number count;</div><div>FixedCrossTableRowSeries rowseries;</div><div>FixedCrossTableDataItem dataItemAbs;</div><div>FixedCrossTableDataItem dataItemPct;</div><div>FixedCrossTableDataSeries dataserie;</div><div> </div><div>dataserie = new FixedCrossTableDataSeries();</div><div>count = count() where D_Week == [201401-201453] && Gender == [1];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div> </div><div>count = count() where D_Week == [201401-201453] && Gender == [2];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div> </div><div>count = count() where D_Week == [201401-201453];</div><div>dataserie.AbsoluteTotal.Value = count;</div><div>dataserie.PercentageTotal.Value = count/count * 100;</div><div>rowseries.Add(dataserie);</div><div>arrRowseries = {rowseries,rowseries,rowseries};</div><div>// Set up a table</div><div>FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty);</div><div>// genarate table:</div><div>createFixedCrossDiagram(table1x1);</div>
	\|}		\|}

Hovietluu at 02:18, 8 December 2015

2015-12-08T02:18:51Z

← Older revision		Revision as of 02:18, 8 December 2015
Line 3:		Line 3:
	==== createFixedCrossDiagram ====		==== createFixedCrossDiagram ====

	Creates a cross diagram ~~from the axis names specified as string arrays for rows and columns. A unique id is returned when a diagram is added~~.		Creates a custom cross diagram.

	'''Syntax'''		'''Syntax'''

Hovietluu at 02:18, 8 December 2015

2015-12-08T02:18:15Z

← Older revision	Revision as of 02:18, 8 December 2015
Line 1:	Line 1:
		{{HelpFiles}}

		==== createFixedCrossDiagram ====

		Creates a cross diagram from the axis names specified as string arrays for rows and columns. A unique id is returned when a diagram is added.

		'''Syntax'''

		createFixedCrossDiagram(FixedCrossTable)

		'''Arguments'''

		FixedCrossTable'':'' An FixedCrossTable expression.

		'''Return type'''

		''number''

		'''Examples'''

		{\| border="1" cellspacing="0" cellpadding="0" style="width: 1000px"
		\|-
		\| <div>DCS_use(15517112);</div><div> </div><div>// Get Axis:</div><div>array axisPrimary = Axis_new("LuuTest1");</div><div>axisPrimary[AXIS_TEXT] = "Choose a D_Week";</div><div> </div><div>array axisSecond = Axis_new("LuuTest2");</div><div>axisSecond[AXIS_TEXT] = "Choose a Region";</div><div> </div><div>Axis_addOption(axisPrimary, AxisOption_new("Year 2014", ""));</div><div>Axis_addOption(axisPrimary, AxisOption_new("Other Year", ""));</div><div> </div><div>Axis_addOption(axisSecond, AxisOption_new("Male", ""));</div><div>Axis_addOption(axisSecond, AxisOption_new("Female", ""));</div><div>// Init:</div><div>array arrRowseries ={};</div><div>number countTotal = count() where true;</div><div>number count;</div><div>FixedCrossTableRowSeries rowseries;</div><div>FixedCrossTableDataItem dataItemAbs;</div><div>FixedCrossTableDataItem dataItemPct;</div><div>FixedCrossTableDataSeries dataserie;</div><div> </div><div>dataserie = new FixedCrossTableDataSeries();</div><div>count = count() where D_Week == [201401-201453] && Gender == [1];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div> </div><div>count = count() where D_Week == [201401-201453] && Gender == [2];</div><div>dataItemAbs = new FixedCrossTableDataItem();</div><div>dataItemAbs.Value = count;</div><div>dataItemPct = new FixedCrossTableDataItem();</div><div>dataItemPct.Value = count100/countTotal;</div><div>dataserie.Add(dataItemAbs,dataItemPct);</div><div> </div><div>count = count() where D_Week == [201401-201453];</div><div>dataserie.AbsoluteTotal.Value = count;</div><div>dataserie.PercentageTotal.Value = count/count * 100;</div><div>rowseries.Add(dataserie);</div><div>arrRowseries = {rowseries,rowseries,rowseries};</div><div>// Set up a table</div><div>// table 2x0</div><div> </div><div> </div><div>FixedCrossTable table1x1 = new FixedCrossTable("Create by createFixedCrossDiagram ", axisPrimary,"Col title", axisSecond, arrRowseries, empty);</div><div>// genarate table:</div><div>createFixedCrossDiagram(table1x1);</div>
		\|}

		'''Availability'''

		Version 6.0 __NOTOC__
		<!-- imported from file: 4223.htm-->

Hovietluu: Blanked the page

2015-12-07T10:41:22Z

Blanked the page

← Older revision		Revision as of 10:41, 7 December 2015
Line 1:		Line 1:
	~~{{Function_Template\|Name=createFixedCrossDiagram\|ReturnType=Number~~
	~~\|Parameters=~~
	~~\|Name=FixedCrossTable\|ConstantType=Object~~
	}}

Hovietluu: Created page with "{{Function_Template|Name=createFixedCrossDiagram|ReturnType=Number |Parameters= |Name=FixedCrossTable|ConstantType=Object }}"

2015-12-07T10:40:25Z

Created page with "{{Function_Template|Name=createFixedCrossDiagram|ReturnType=Number |Parameters= |Name=FixedCrossTable|ConstantType=Object }}"

New page

{{Function_Template|Name=createFixedCrossDiagram|ReturnType=Number
|Parameters=
|Name=FixedCrossTable|ConstantType=Object
}}