Diagram 2 - Revision history

Catglobe at 06:51, 7 September 2009

2009-09-07T06:51:31Z

@@ Line 21: / Line 21: @@
 {| style="width: 634px; height: 296px" border="1" cellspacing="1" cellpadding="1" width="634"
 |-
-| // CGScript<br>array a = stringSplit(EndDate, " "); // get value of the EndDate column<br>string s = a[0];<br>a = stringSplit(s, "/");<br>number endDateYear = convertToNumber(a[2]); // get the year of the date in the EndDate column<br>number endDateMonth = convertToNumber(a[0]); // get the month of the date in the EndDate column<br>number endDateDay = convertToNumber(a[1]); // get the&nbsp;day of the date in the EndDate column<br>array today = getDateTime();<br>number todayYear = today[DateTime_Year];<br>number todayMonth = today[DateTime_Month];<br>number IsLastYear = 1;<br>number IsThisYear = 0;<br>if (endDateYear == todayYear)<br>return IsThisYear;<br>if (endDateYear == todayYear-1)<br>return IsLastYear;<br>//End Script
+| // CGScript<br>&nbsp;array a = DateTime_parse(EndDate, "MM/dd/yyyy");
 |}
@@ Line 48: / Line 68: @@
 {| border="1" cellspacing="1" cellpadding="1" width="500"
 |-
-| // CGScript<br>array a = stringSplit(EndDate, " ");<br>string s = a[0];<br>a = stringSplit(s, "/");<br>number endDateYear = convertToNumber(a[2]);<br>number endDateMonth = convertToNumber(a[0]);<br>number endDateDay = convertToNumber(a[1]);<br>return endDateMonth;<br>//End Script
+| // CGScript<br>array a = DateTime_parse(EndDate, "MM/dd/yyyy");
 |}

Catglobe at 08:48, 4 September 2009

2009-09-04T08:48:34Z

← Older revision		Revision as of 08:48, 4 September 2009
Line 40:		Line 40:
	'''4. Save the Data cache.'''		'''4. Save the Data cache.'''

	'''<u>Step 2. </u>Create a new axis set in DCS list based on the EndDate column, this axis will be used as the x-axis of the cross diagram in Dashboard.<br>''' '''1. Open the Data Cache in Data Cache list '''(Tools/ Data / Data Caches)<br> '''2. In the Data Cache tab:'''<br>  '''''2.1. Select Column’s type then click “Add Column” button to insert a new Custom column.<br>'''''         - A new Custom column is used to define the month of EndDate.<br>         - Data type : Number <br>         - Save numbers : 1,2,3,4,5,6,7,8,9,10,11 and 12.<br>              1: the month of the EndDate is January.<br>              2: the month of the EndDate is February.<br>              3: the month of the EndDate is March.<br>              4: the month of the EndDate is April.<br>              5: the month of the EndDate is May.<br>              6: the month of the EndDate is June.<br>              7: the month of the EndDate is July.<br>              8: the month of the EndDate is August.<br>              9: the month of the EndDate is September.<br>             10: the month of the EndDate is October.<br>             11: the month of the EndDate is November.<br>             12: the month of the EndDate is December.		'''<u>Step 2. </u>Create a new axis set in DCS list based on the EndDate column, this axis will be used as the x-axis of the cross diagram in Dashboard.<br>''' '''1. Open the Data Cache in Data Cache list '''(Tools/ Data / Data Caches)<br> '''2. In the Data Cache tab:'''<br>  '''''2.1. Select Column’s type then click “Add Column” button to insert a new Custom column.<br>'''''         - A new Custom column is used to define the month of EndDate.<br>         - Data type : Number <br>         - Save numbers : 1,2,3,4,5,6,7,8,9,10,11 and 12.<br>              1: the month of the EndDate is January.<br>              2: the month of the EndDate is February.<br>              3: the month of the EndDate is March.<br>              4: the month of the EndDate is April.<br>              5: the month of the EndDate is May.<br>              6: the month of the EndDate is June.<br>              7: the month of the EndDate is July.<br>              8: the month of the EndDate is August.<br>              9: the month of the EndDate is September.<br>             10: the month of the EndDate is October.<br>             11: the month of the EndDate is November.<br>             12: the month of the EndDate is December.

	<br>''   '''2.2 Put the CGScript which defines Current Year and Last Year'''''<b>         [[Image:Insert script.JPG]]</b>		<br>''   '''2.2 Put the CGScript which defines Current Year and Last Year'''''<b>         [[Image:Insert script.JPG]]</b>
Line 129:		Line 129:
	<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> '''1. Go to Dashboard list '''(Tools/ Reports/ Dashboard).<br>         [[Image:Dash 1.JPG]]		<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> '''1. Go to Dashboard list '''(Tools/ Reports/ Dashboard).<br>         [[Image:Dash 1.JPG]]

	<br> '''2. Create a new dashboard or edit an existing one. '''<br> '''3. In General Information tab''': Data caches list must have the DCS which is created at step 1&2.<br> '''~~ ~~4. Layout tab''': Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         [[Image:Dash 2.JPG]]		<br> '''2. Create a new dashboard or edit an existing one. '''<br> '''3. In General Information tab''': Data caches list must have the DCS which is created at step 1&2.<br> '''4. Layout tab''': Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         [[Image:Dash 2.JPG]]

	<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec		<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec
Line 139:		Line 139:
	<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]		<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]

	<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  '''5. Insert these Dashboard items to the HTML editor then save the Dashboard.'''		<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  '''5. Insert these Dashboard items to the HTML editor then save the Dashboard.'''

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 08:22, 4 September 2009

2009-09-04T08:22:41Z

Catglobe at 08:13, 4 September 2009

2009-09-04T08:13:44Z

← Older revision		Revision as of 08:13, 4 September 2009
Line 5:		Line 5:
	= The following steps show you how to create the above diagram =		= The following steps show you how to create the above diagram =

	<u>'''Step 1.'''</u>'''Create a new axis set in DCS list based on the EndDate column, this axis will be used as the y-axis of the cross diagram in Dashboard.'''<br> '''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches)<br> [[Image:~~Dash_0~~.JPG]] .<br>''' 2. In the Data Cache tab:''' <br>   '''2.1 Select Column’s type then click “Add Column” button to insert a new Custom column'''<br>                                 [[Image:Add custom.JPG]]		<u>'''Step 1.'''</u>'''Create a new axis set in DCS list based on the EndDate column, this axis will be used as the y-axis of the cross diagram in Dashboard.'''<br> '''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches)<br>           [[Image:Dash 0.JPG]] .

			<br>''' 2. In the Data Cache tab:''' <br>   '''2.1 Select Column’s type then click “Add Column” button to insert a new Custom column'''<br>                                 [[Image:Add custom.JPG]]

	<br>		<br>
Line 23:		Line 25:

	- Save the Custom column.<br><br> '''3. Go to the Axis set tab''''': ''Create a new axis set''' <br>'''''<b>   </b>3.1 Create a new axis set<br>       ''''''[[Image:Create new axis.JPG\|269x392px]]'''		- Save the Custom column.<br><br> '''3. Go to the Axis set tab''''': ''Create a new axis set''' <br>'''''<b>   </b>3.1 Create a new axis set<br>       ''''''[[Image:Create new axis.JPG\|269x392px]]'''



	''3.2 Input value to the new axis set''		''3.2 Input value to the new axis set''
Line 121:		Line 125:


	<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> [[Image:~~Dash_1~~.JPG]]		<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br>         [[Image:Dash 1.JPG]]
	<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>
	[[Image:~~Dash_2~~.JPG]] <br>		<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         [[Image:Dash 2.JPG]]
	o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>
	[[Image:~~Dash_2~~.JPG]] <br>		<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec
	o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>
	[[Image:~~Dash_3~~.JPG]] <br>		<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>          [[Image:Dash 2.JPG]]
	o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.
			<br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.

			<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]

			<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 08:11, 4 September 2009

2009-09-04T08:11:59Z

← Older revision		Revision as of 08:11, 4 September 2009
Line 5:		Line 5:
	= The following steps show you how to create the above diagram =		= The following steps show you how to create the above diagram =

	<u>'''Step 1.'''</u>'''Create a new axis set in DCS list based on the EndDate column, this axis will be used as the y-axis of the cross diagram in Dashboard.'''<br> '''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches).<br>''' 2. In the Data Cache tab:''' <br>   '''2.1 Select Column’s type then click “Add Column” button to insert a new Custom column'''<br>                                 [[Image:Add custom.JPG]]		<u>'''Step 1.'''</u>'''Create a new axis set in DCS list based on the EndDate column, this axis will be used as the y-axis of the cross diagram in Dashboard.'''<br> '''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches)<br> [[Image:Dash_0.JPG]] .<br>''' 2. In the Data Cache tab:''' <br>   '''2.1 Select Column’s type then click “Add Column” button to insert a new Custom column'''<br>                                 [[Image:Add custom.JPG]]

	<br>		<br>
Line 123:		Line 123:
	<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> [[Image:Dash_1.JPG]]		<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> [[Image:Dash_1.JPG]]
	<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>		<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>
	[[Image:Dash_2.JPG]]		[[Image:Dash_2.JPG]] <br>
	o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>		o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>
	[[Image:Dash_2.JPG]]		[[Image:Dash_2.JPG]] <br>
	o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>		o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>
	[[Image:Dash_3.JPG]]		[[Image:Dash_3.JPG]] <br>
	o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.		o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 08:06, 4 September 2009

2009-09-04T08:06:04Z

← Older revision		Revision as of 08:06, 4 September 2009
Line 121:		Line 121:


	<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.		<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> [[Image:Dash_1.JPG]]
			<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>
			[[Image:Dash_2.JPG]]
			o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>
			[[Image:Dash_2.JPG]]
			o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>
			[[Image:Dash_3.JPG]]
			o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 07:54, 4 September 2009

2009-09-04T07:54:54Z

← Older revision		Revision as of 07:54, 4 September 2009
Line 121:		Line 121:


	<br>'''4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.		<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 07:54, 4 September 2009

2009-09-04T07:54:02Z

← Older revision		Revision as of 07:54, 4 September 2009
Line 121:		Line 121:


	<br>		<br>'''4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	'''~~<br><br>~~4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> 1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> 2. Create a new dashboard or edit an existing one. <br> 3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br> 4. Layout tab: Create Dashboard items.<br>   4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>     o Data cache: use the DCS which is created at step 1&2.<br>     o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>   4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>     o Data cache : use the DCS which is created at step 1&2.<br>     o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>   4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>     o Data cache: use the DCS which is created at step 1&2.<br>     o Chart type: Line<br>     o X – axis: must be DB item 4.1<br>     o Y – axis: must be DB item 4.2<br>     o Style sheet: choose a style sheet which is created in the Style sheet list.<br>     o Data format: absolute<br>     o Direction: Vertical<br> 5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 07:52, 4 September 2009

2009-09-04T07:52:46Z

← Older revision		Revision as of 07:52, 4 September 2009
Line 123:		Line 123:
	<br>		<br>

	'''<br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> 1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> 2. Create a new dashboard or edit an existing one. <br> 3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br> 4. Layout tab: Create Dashboard items.<br>   4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>     o Data cache: use the DCS which is created at step 1&2.<br>     o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>   4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>     o Data cache : use the DCS which is created at step 1&2.<br>     o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>   4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>     o Data cache: use the DCS which is created at step 1&2.<br>     o Chart type: Line<br>     o X – axis: must be DB item 4.1<br>     o Y – axis: must be DB item 4.2<br>     o Style sheet: choose a style sheet which is created in the Style sheet list.<br>     o Data format: absolute<br>     o Direction: Vertical<br> 5. Insert these Dashboard items to the HTML editor then save the Dashboard.		'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> 1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> 2. Create a new dashboard or edit an existing one. <br> 3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br> 4. Layout tab: Create Dashboard items.<br>   4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>     o Data cache: use the DCS which is created at step 1&2.<br>     o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>   4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>     o Data cache : use the DCS which is created at step 1&2.<br>     o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>   4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>     o Data cache: use the DCS which is created at step 1&2.<br>     o Chart type: Line<br>     o X – axis: must be DB item 4.1<br>     o Y – axis: must be DB item 4.2<br>     o Style sheet: choose a style sheet which is created in the Style sheet list.<br>     o Data format: absolute<br>     o Direction: Vertical<br> 5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

Catglobe at 07:52, 4 September 2009

2009-09-04T07:52:26Z

← Older revision		Revision as of 07:52, 4 September 2009
Line 123:		Line 123:
	<br>		<br>

	'''4. Save the Data Cache.<br>~~''''''~~<u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> 1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> 2. Create a new dashboard or edit an existing one. <br> 3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br> 4. Layout tab: Create Dashboard items.<br>   4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>     o Data cache: use the DCS which is created at step 1&2.<br>     o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>   4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>     o Data cache : use the DCS which is created at step 1&2.<br>     o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>   4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>     o Data cache: use the DCS which is created at step 1&2.<br>     o Chart type: Line<br>     o X – axis: must be DB item 4.1<br>     o Y – axis: must be DB item 4.2<br>     o Style sheet: choose a style sheet which is created in the Style sheet list.<br>     o Data format: absolute<br>     o Direction: Vertical<br> 5. Insert these Dashboard items to the HTML editor then save the Dashboard.		'''<br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> 1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br> 2. Create a new dashboard or edit an existing one. <br> 3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br> 4. Layout tab: Create Dashboard items.<br>   4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>     o Data cache: use the DCS which is created at step 1&2.<br>     o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec<br>   4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>     o Data cache : use the DCS which is created at step 1&2.<br>     o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.<br>   4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>     o Data cache: use the DCS which is created at step 1&2.<br>     o Chart type: Line<br>     o X – axis: must be DB item 4.1<br>     o Y – axis: must be DB item 4.2<br>     o Style sheet: choose a style sheet which is created in the Style sheet list.<br>     o Data format: absolute<br>     o Direction: Vertical<br> 5. Insert these Dashboard items to the HTML editor then save the Dashboard.

	// Finish creating the diagram.		// Finish creating the diagram.

← Older revision		Revision as of 08:22, 4 September 2009
Line 5:		Line 5:
	= The following steps show you how to create the above diagram =		= The following steps show you how to create the above diagram =

	<u>'''Step 1.'''</u>'''Create a new axis set in DCS list based on the EndDate column, this axis will be used as the y-axis of the cross diagram in Dashboard.'''<br> '''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches)<br>           [[Image:Dash 0.JPG]] .		<u>'''Step 1.'''</u>'''Create a new axis set in DCS list based on the EndDate column, this axis will be used as the y-axis of the cross diagram in Dashboard.'''<br> '''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches)<br>           [[Image:Dash 0.JPG]] .

	<br>''' 2. In the Data Cache tab:''' <br>   '''2.1 Select Column’s type then click “Add Column” button to insert a new Custom column'''<br>                                 [[Image:Add custom.JPG]]		<br>''' 2. In the Data Cache tab:''' <br>   '''2.1 Select Column’s type then click “Add Column” button to insert a new Custom column'''<br>                                 [[Image:Add custom.JPG]]
Line 19:		Line 19:


	{\| border="1" cellspacing="1" cellpadding="1" width="~~500~~"		{\| style="width: 634px; height: 296px" border="1" cellspacing="1" cellpadding="1" width="634"
	\|-		\|-
	\| // CGScript<br>array a = stringSplit(EndDate, " ");<br>string s = a[0];<br>a = stringSplit(s, "/");<br>number endDateYear = convertToNumber(a[2]);<br>number endDateMonth = convertToNumber(a[0]);<br>number endDateDay = convertToNumber(a[1]);<br>array today = getDateTime();<br>number todayYear = today[DateTime_Year];<br>number todayMonth = today[DateTime_Month];<br>number IsLastYear = 1;<br>number IsThisYear = 0;<br>if (endDateYear == todayYear)<br>return IsThisYear;<br>if (endDateYear == todayYear-1)<br>return IsLastYear;<br>//End Script		\| // CGScript<br>array a = stringSplit(EndDate, " "); // get value of the EndDate column<br>string s = a[0];<br>a = stringSplit(s, "/");<br>number endDateYear = convertToNumber(a[2]); // get the year of the date in the EndDate column<br>number endDateMonth = convertToNumber(a[0]); // get the month of the date in the EndDate column<br>number endDateDay = convertToNumber(a[1]); // get the day of the date in the EndDate column<br>array today = getDateTime();<br>number todayYear = today[DateTime_Year];<br>number todayMonth = today[DateTime_Month];<br>number IsLastYear = 1;<br>number IsThisYear = 0;<br>if (endDateYear == todayYear)<br>return IsThisYear;<br>if (endDateYear == todayYear-1)<br>return IsLastYear;<br>//End Script
	\|}		\|}

	- Save the Custom column.<br><br> '''3. Go to the Axis set tab''''': ''Create a new axis set''' <br>'''''<b>   </b>3.1 Create a new axis set<br>       ''''''[[Image:Create new axis.JPG\|269x392px]]'''		- Save the Custom column.<br><br> '''3. Go to the Axis set tab''''': ''Create a new axis set''' <br>'''''<b>   </b>3.1 Create a new axis set<br>       ''''''[[Image:Create new axis.JPG\|269x392px]]'''

			<br>

	''3.2 Input value to the new axis set''		''3.2 Input value to the new axis set''
Line 40:		Line 40:
	'''4. Save the Data cache.'''		'''4. Save the Data cache.'''

	'''<u>Step 2. </u>Create a new axis set in DCS list based on the EndDate column, this axis will be used as the x-axis of the cross diagram in Dashboard.<br>''' '''1. Open the Data Cache in Data Cache list '''(Tools/ Data / Data Caches)<br> '''2. In the Data Cache tab:'''<br>  '''''2.1. Select Column’s type then click “Add Column” button to insert a new Custom column.<br>'''''         - A new Custom column is used to define the month of EndDate.<br>         - Data type : Number <br>         - Save numbers : 1,2,3,4,5,6,7,8,9,10,11 and 12.<br>              1: the month of the EndDate is January.<br>              2: the month of the EndDate is February.<br>              3: the month of the EndDate is March.<br>              4: the month of the EndDate is April.<br>              5: the month of the EndDate is May.<br>              6: the month of the EndDate is June.<br>              7: the month of the EndDate is July.<br>              8: the month of the EndDate is August.<br>              9: the month of the EndDate is September.<br>             10: the month of the EndDate is October.<br>             11: the month of the EndDate is November.<br>             12: the month of the EndDate is December.<br>''   '''2.2 Put the CGScript which defines Current Year and Last Year'''''<b>         [[Image:Insert script.JPG]]</b>		'''<u>Step 2. </u>Create a new axis set in DCS list based on the EndDate column, this axis will be used as the x-axis of the cross diagram in Dashboard.<br>''' '''1. Open the Data Cache in Data Cache list '''(Tools/ Data / Data Caches)<br> '''2. In the Data Cache tab:'''<br>  '''''2.1. Select Column’s type then click “Add Column” button to insert a new Custom column.<br>'''''         - A new Custom column is used to define the month of EndDate.<br>         - Data type : Number <br>         - Save numbers : 1,2,3,4,5,6,7,8,9,10,11 and 12.<br>              1: the month of the EndDate is January.<br>              2: the month of the EndDate is February.<br>              3: the month of the EndDate is March.<br>              4: the month of the EndDate is April.<br>              5: the month of the EndDate is May.<br>              6: the month of the EndDate is June.<br>              7: the month of the EndDate is July.<br>              8: the month of the EndDate is August.<br>              9: the month of the EndDate is September.<br>             10: the month of the EndDate is October.<br>             11: the month of the EndDate is November.<br>             12: the month of the EndDate is December.

			<br>''   '''2.2 Put the CGScript which defines Current Year and Last Year'''''<b>         [[Image:Insert script.JPG]]</b>

	<br><span style="display: none" id="1251963061441S"> </span>- Input Name of the Custom column, this name will be an option of the axis set.<br> - Insert the CGSript.		<br><span style="display: none" id="1251963061441S"> </span>- Input Name of the Custom column, this name will be an option of the axis set.<br> - Insert the CGSript.
Line 125:		Line 127:


	<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br>  1. Go to Dashboard list (Tools/ Reports/ Dashboard).<br>         [[Image:Dash 1.JPG]]		<br>'''<br><br>4. Save the Data Cache.<br><u>Step 3. </u>Create Dashboard item whose type is Cross diagram.'''<br> '''1. Go to Dashboard list '''(Tools/ Reports/ Dashboard).<br>         [[Image:Dash 1.JPG]]

	<br>  2. Create a new dashboard or edit an existing one. <br>  3. In General Information tab: Data caches list must have the DCS which is created at step 1&2.<br>  4. Layout tab: Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         [[Image:Dash 2.JPG]]		<br> '''2. Create a new dashboard or edit an existing one. '''<br> '''3. In General Information tab''': Data caches list must have the DCS which is created at step 1&2.<br> ''' 4. Layout tab''': Create Dashboard items.<br>      4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         [[Image:Dash 2.JPG]]

	<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec		<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o This DB item will be used as the X-axis of the cross diagram that has 12 options: Jan, Feb, Mar,… Dec

	<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>          [[Image:Dash 2.JPG]]		<br>      4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>          [[Image:Dash 2.JPG]]

	<br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.		<br>         o Data cache : use the DCS which is created at step 1&2.<br>         o This DB item will be used as Y-axis of the cross diagram that has 2 options: Last Year and This Year.

	<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]		<br>      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]

	<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  5. Insert these Dashboard items to the HTML editor then save the Dashboard.		<br>         o Data cache: use the DCS which is created at step 1&2.<br>         o Chart type: Line<br>         o X – axis: must be DB item 4.1<br>         o Y – axis: must be DB item 4.2<br>         o Style sheet: choose a style sheet which is created in the Style sheet list.<br>         o Data format: absolute<br>         o Direction: Vertical<br>  '''5. Insert these Dashboard items to the HTML editor then save the Dashboard.'''

	// Finish creating the diagram.		// Finish creating the diagram.