Diagram 1 - Revision history

Catglobe at 07:34, 10 September 2009

2009-09-10T07:34:01Z

← Older revision		Revision as of 07:34, 10 September 2009
Line 1:		Line 1:
	[[Image:Diagram 1.JPG]]		[[Image:Diagram 1.JPG]]

	The diagram above is a cross diagram which is made by crossing 2 axes together:		The diagram above is a cross diagram which is made by crossing 2 axes together:

	- The X-axis has 4 options : Custom Service, Product, Web site and Brand.		- The X-axis has 4 options : Custom Service, Product, Web site and Brand.
Line 9:		Line 9:
	= 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.'''		<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.'''
	~~'''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:'''		'''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:'''

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

	- A new Custom column is used to define the quarters.		- A new Custom column is used to define the quarters.

	- Data type : Number		- Data type : Number

	- Save numbers : 0,1,4 and null.		- Save numbers : 0,1,4 and null.

	0 : if the date of the EndDate column is the same quarter with the current date in the system		0 : if the date of the EndDate column is the same quarter with the current date in the system
Line 34:		Line 35:
	'''2.2 Put the CGScript which defines Current Year and Last Year'''<br><span id="fck_dom_range_temp_1251961601465_789">         [[Image:Insert script.JPG\|693x230px]]</span>		'''2.2 Put the CGScript which defines Current Year and Last Year'''<br><span id="fck_dom_range_temp_1251961601465_789">         [[Image:Insert script.JPG\|693x230px]]</span>

	- Input Name of the Custom column, this name will be an option of the axis set.		- Input Name of the Custom column, this name will be an option of the axis set.

	- Insert the CGSript.      <br>		- Insert the CGSript.      <br>
Line 103:		Line 104:
	\|}		\|}

	- Save the Custom column.		- Save the Custom column.

			'''3. Go to the Axis set tab''''': ''Create a new axis set''' ''' '''''  '''''

	~~ ~~''~~'3. Go to the Axis set tab''''': ''Create a new axis set~~''' ~~'''~~		'''''       '''3.1 Create a new axis set<br>       ''''''[[Image:Create new axis.JPG\|269x392px]]'''
	~~'''''~~   '''3.1 Create a new axis set<br>       ''''''[[Image:Create new axis.JPG\|269x392px]]'''

	<br>		<br>
Line 122:		Line 124:
	'''4. Save the Data cache.'''		'''4. Save the Data cache.'''

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

			'''2. Create a new dashboard or edit an existing one. '''

	~~ ~~'''~~2. Create a new dashboard or edit an existing one.~~ ~~'''~~		'''   3. In General Information tab''': Data caches list must have the DCS which is created at step 1.
	~~'''~~3. In General Information tab''': Data caches list must have the DCS which is created at step 1.

	'''4. Layout tab''': Create Dashboard items.		'''4. Layout tab''': Create Dashboard items.

	4.1 Create Dashboard (DB) item 1 whose type is Shown axis. <br>         [[Image:Dash 2.JPG]]		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.		<br>         o Data cache: use the DCS which is created at step 1.

	o This DB item will be used as the X-axis of the cross diagram that has 4 options: Custom Service, Product, Web site and Brand.		o This DB item will be used as the X-axis of the cross diagram that has 4 options: Custom Service, Product, Web site and Brand.
Line 138:		Line 142:
	4.2 Create Dashboard (DB) item 2 whose type is Shown axis. <br>          [[Image:Dash 2.JPG]]		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.		<br>         o Data cache : use the DCS which is created at step 1.

	o This DB item will be used as Y-axis of the cross diagram that has 3 options: Same Quarter Last Year, This Quarter and Last Quarter.		o This DB item will be used as Y-axis of the cross diagram that has 3 options: Same Quarter Last Year, This Quarter and Last Quarter.
Line 144:		Line 148:
	4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]		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.		<br>         o Data cache: use the DCS which is created at step 1.

	o Chart type: Bar		o Chart type: Bar

	o X – axis: must be DB item 4.1		o X – axis: must be DB item 4.1

	o Y – axis: must be DB item 4.2		o Y – axis: must be DB item 4.2

	o Style sheet: choose a style sheet which is created in the Style sheet list.		o Style sheet: choose a style sheet which is created in the Style sheet list.

	o Data format: absolute		o Data format: absolute

	o Direction: Vertical		o Direction: Vertical

	'''5. Insert these Dashboard items to the HTML editor then save the Dashboard.'''		'''5. Insert these Dashboard items to the HTML editor then save the Dashboard.'''

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

Catglobe at 07:32, 10 September 2009

2009-09-10T07:32:59Z

Show changes

Catglobe at 07:31, 10 September 2009

2009-09-10T07:31:04Z

← Older revision		Revision as of 07:31, 10 September 2009
Line 13:		Line 13:
	<br>		<br>

	- A new Custom column is used to define the quarters.<br>           - Data type : Number <br>           - Save numbers : 0,1,4 and null.<br>                 0 : if the date of the EndDate column is the same quarter with the current date in the system.		- A new Custom column is used to define the quarters.<br>           - Data type : Number <br>           - Save numbers : 0,1,4 and null.<br>                 0 : if the date of the EndDate column is the same quarter with the current date in the system

	1 : if the date of the EndDate column is in the previous quarter of current date in the system.~~<br>~~                 4 : if the date of the EndDate column is in the same quarter but in last year of current date in the system.~~<br>~~                 Null : if the date of the EndDate column is in other quarters.		1 : if the date of the EndDate column is in the previous quarter of current date in the system.

			4 : if the date of the EndDate column is in the same quarter but in last year of current date in the system.

			Null : if the date of the EndDate column is in other quarters.

	'''2.2 Put the CGScript which defines Current Year and Last Year'''<br><span id="fck_dom_range_temp_1251961601465_789">         [[Image:Insert script.JPG\|693x230px]]</span>		'''2.2 Put the CGScript which defines Current Year and Last Year'''<br><span id="fck_dom_range_temp_1251961601465_789">         [[Image:Insert script.JPG\|693x230px]]</span>
Line 106:		Line 110:
	'''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.<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]]		'''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.<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.<br>         o This DB item will be used as the X-axis of the cross diagram that has 4 options: Custom Service, Product, Web site and Brand.		<br>         o Data cache: use the DCS which is created at step 1.<br>         o This DB item will be used as the X-axis of the cross diagram that has 4 options: Custom Service, Product, Web site and Brand.

	<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]]
Line 112:		Line 116:
	<br>         o Data cache : use the DCS which is created at step 1.<br>         o This DB item will be used as Y-axis of the cross diagram that has 3 options: Same Quarter Last Year, This Quarter and Last Quarter.		<br>         o Data cache : use the DCS which is created at step 1.<br>         o This DB item will be used as Y-axis of the cross diagram that has 3 options: Same Quarter Last Year, This Quarter and Last Quarter.

	~~<br>~~      4.3 Create Dashboard (DB) item 3 whose type is Cross diagram :<br>         [[Image:Dash 3.JPG]]		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.<br>         o Chart type: Bar<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.<br>         o Chart type: Bar<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.

	~~'''<br> '''<br> ~~

Catglobe at 07:28, 10 September 2009

2009-09-10T07:28:44Z

Catglobe at 07:23, 10 September 2009

2009-09-10T07:23:34Z

← Older revision		Revision as of 07:23, 10 September 2009
Line 1:		Line 1:
	[[Image:Diagram 2.JPG]]		[[Image:Diagram 1.JPG]]

	The diagram above is a cross diagram which is made by crossing 2 axes together:<br>- The X-axis has 4 options : Custom Service, Product, Web site and Brand.		The diagram above is a cross diagram which is made by crossing 2 axes together:<br>- The X-axis has 4 options : Custom Service, Product, Web site and Brand.

	- The Y- axis has 3 options: Same Quarter Last Year, Last Quarter and This Quarter. Calculations for these options are based on values stored in a custom column in the data cache. These values, which are calculated on corresponding values in the EndDate column, indicate whether an RPQ was finished in this this quarter, last quarter or the same quarter last year.		- The Y- axis has 3 options: Same Quarter Last Year, Last Quarter and This Quarter. Calculations for these options are based on values stored in a custom column in the data cache. These values, which are calculated on corresponding values in the EndDate column, indicate whether an RPQ was finished in this this quarter, last quarter or the same quarter last year.
Line 13:		Line 13:
	<br>		<br>

	- A new Custom column is used to define the year which this record is related to.<br>           - Data type : Number <br>           - Save numbers : 0,1 and null.<br>                 0 : if the year of the EndDate column is the same with the current year in the system.		- A new Custom column is used to define the year which this record is related to.<br>           - Data type : Number <br>           - Save numbers : 0,1 and null.<br>                 0 : if the year of the EndDate column is the same with the current year in the system.

	1 : if the year of the EndDate column is in the previous year of current year in the system.<br>                 4 : if the year of the EndDate column is in the previous year of current year in the system.<br>                 Null : if the year of the EndDate column is in other years.		1 : if the year of the EndDate column is in the previous year of current year in the system.<br>                 4 : if the year of the EndDate column is in the previous year of current year in the system.<br>                 Null : if the year of the EndDate column is in other years.
Line 23:		Line 23:


			<br>

	{\| style="width: 634px; height: 296px" border="1" cellspacing="1" cellpadding="1" width="634"		{\| style="width: 634px; height: 296px" border="1" cellspacing="1" cellpadding="1" width="634"
	\|-		\|-
	\| // CGScript<br>		\| // CGScript<br>
	array a = DateTime_parse(EndDate, "MM/dd/yyyy");		array a = DateTime_parse(EndDate, "MM/dd/yyyy");

	array today = getDateTime();		array today = getDateTime();

	number todayYear = today[DateTime_Year];		number todayYear = today[DateTime_Year];

	number todayMonth = today[DateTime_Month];		number todayMonth = today[DateTime_Month];

	number TodayQuarter = 1;		number TodayQuarter = 1;

	number endDateQuarter = 1;		number endDateQuarter = 1;

	number IsLastQuarter = 1;		number IsLastQuarter = 1;

	number IsThisQuarter = 0;		number IsThisQuarter = 0;

	number IsSameQuarterLastYear = 4;		number IsSameQuarterLastYear = 4;

	if (todayMonth == 1 \|\| todayMonth == 2 \|\| todayMonth == 3)		if (todayMonth == 1 \|\| todayMonth == 2 \|\| todayMonth == 3)

	TodayQuarter = 1;		TodayQuarter = 1;

	else if (todayMonth == 4 \|\| todayMonth == 5 \|\| todayMonth == 6)		else if (todayMonth == 4 \|\| todayMonth == 5 \|\| todayMonth == 6)

	TodayQuarter = 2;		TodayQuarter = 2;

	else if (todayMonth == 7 \|\| todayMonth == 8 \|\| todayMonth == 9)		else if (todayMonth == 7 \|\| todayMonth == 8 \|\| todayMonth == 9)

	TodayQuarter = 3;		TodayQuarter = 3;

	else TodayQuarter = 4;		else TodayQuarter = 4;

	if (a[1] == 1 \|\| a[1] == 2 \|\| a[1] == 3)		if (a[1] == 1 \|\| a[1] == 2 \|\| a[1] == 3)

	endDateQuarter = 1;		endDateQuarter = 1;

	else if (a[1] == 4 \|\| a[1] == 5 \|\| a[1] == 6)		else if (a[1] == 4 \|\| a[1] == 5 \|\| a[1] == 6)

	endDateQuarter = 2;		endDateQuarter = 2;

	else if (a[1] == 7 \|\| a[1] == 8 \|\| a[1] == 9)		else if (a[1] == 7 \|\| a[1] == 8 \|\| a[1] == 9)

	endDateQuarter = 3;		endDateQuarter = 3;

	else endDateQuarter = 4;		else endDateQuarter = 4;

	if (a[0] == todayYear && endDateQuarter == TodayQuarter)		if (a[0] == todayYear && endDateQuarter == TodayQuarter)

	return IsThisQuarter;		return IsThisQuarter;

	else if (a[0] == todayYear && TodayQuarter - endDateQuarter == 1)		else if (a[0] == todayYear && TodayQuarter - endDateQuarter == 1)

	return IsLastQuarter;		return IsLastQuarter;

	else if (todayYear - a[0] == 1 && endDateQuarter == TodayQuarter)		else if (todayYear - a[0] == 1 && endDateQuarter == TodayQuarter)

	return IsSameQuarterLastYear;		return IsSameQuarterLastYear;

	//End Script		//End Script
Line 89:		Line 90:
	\|}		\|}

			<br>- 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>		<br>

Catglobe at 07:23, 10 September 2009

2009-09-10T07:23:21Z

Show changes

Catglobe at 07:02, 10 September 2009

2009-09-10T07:02:44Z

← Older revision		Revision as of 07:02, 10 September 2009
Line 5:		Line 5:
	= The following steps show you how to create the above diagram<br> =		= The following steps show you how to create the above diagram<br> =

	'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>  '''1. Open the Time set list (Tools/ ~~Administrator~~ / Report/ Time sets).<br><br>      [[Image:Diagram 3 1.JPG]] '''		'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>  '''1. Open the Time set list (Tools/ Administration / Report/ Time sets).<br><br>      [[Image:Diagram 3 1.JPG]] '''

	'''<br>''' '''2. Create a new Time set: <br>'''   <br>    [[Image:Diagram 3 3.JPG]]		'''<br>''' '''2. Create a new Time set: <br>'''   <br>    [[Image:Diagram 3 3.JPG]]
Line 13:		Line 13:
	- The new Time set is used to define the period of time. <br>     - Type: Month  <br>     - Label format : select type likes "Sep 2009"<br>     - Span : select 6 if user want to show value for each 6 months, or select Span = 3 if user want to show value for each quarter.		- The new Time set is used to define the period of time. <br>     - Type: Month  <br>     - Label format : select type likes "Sep 2009"<br>     - Span : select 6 if user want to show value for each 6 months, or select Span = 3 if user want to show value for each quarter.

	'''3. Save ~~this~~ time set'''		'''3. Save the time set.'''

	<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>  1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<br>'''        [[Image:Dash 1.JPG]]'''		<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>  1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<br>'''        [[Image:Dash 1.JPG]]'''

Catglobe at 07:00, 10 September 2009

2009-09-10T07:00:03Z

← Older revision		Revision as of 07:00, 10 September 2009
Line 11:		Line 11:
	<br>		<br>

	- The new Time set is used to define the period of time. <br>     - Type: Month  <br>     - Label format : select type likes "Sep 2009"<br>     - Span : select 6 if user want to show value each 6 months, or select Span = 3 if user want to show value each quarter.		- The new Time set is used to define the period of time. <br>     - Type: Month  <br>     - Label format : select type likes "Sep 2009"<br>     - Span : select 6 if user want to show value for each 6 months, or select Span = 3 if user want to show value for each quarter.

	'''3. Save this time set'''		'''3. Save this time set'''
Line 19:		Line 19:
	'''<br> 2. Create a new dashboard or edit an existing one.''' <br> '''3. In General Information tab: '''Data caches list must be added the DCS which is used to make Cross diagram.<br> '''4. Layout tab: '''Create Dashboard items<br>  '''4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>'''          [[Image:D 3 5.JPG]]		'''<br> 2. Create a new dashboard or edit an existing one.''' <br> '''3. In General Information tab: '''Data caches list must be added the DCS which is used to make Cross diagram.<br> '''4. Layout tab: '''Create Dashboard items<br>  '''4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>'''          [[Image:D 3 5.JPG]]

	<br>     o Data cache: use the DCS which is used to make Cross diagram.<br>     o Time set : select the Time set which is created at step 1.		<br>     o Data cache: use the DCS which is used to make Cross diagram.<br>     o Time set : select the Time set which is created at step 1.

	o Column ~~: select EndDate~~		o Column : select EndDate

	~~     o~~ ~~Start date~~ : select ~~the 1st of June.~~

			o Start date : select the 1st of June.

			<br>

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

Catglobe at 06:59, 10 September 2009

2009-09-10T06:59:14Z

← Older revision		Revision as of 06:59, 10 September 2009
Line 1:		Line 1:
	[[Image:Diagram 3.JPG]]~~ <span id="fck_dom_range_temp_1252565107133_175" /><span id="fck_dom_range_temp_1252565107133_224" />~~		[[Image:Diagram 3.JPG]]

	The diagram above is a cross diagram which is made by crossing 2 axes together:<br>- The x-axis ~~has 4 options: Custom Service, Product, Web site and Brand~~.<br>- The y-axis ~~has 3 options: Same Quarter Last Year, Last Quarter and This Quarter. Calculations for these options are based on values stored in a custom column in~~ the ~~data cache. These values,~~ which ~~are calculated on corresponding values in the EndDate column, indicate whether an RPQ was finished in this quarter, last quarter, or the same quarter last year~~.		The diagram above is a cross diagram which is made by crossing 2 axes together:<br>- The x-axis will be used a time set.<br>- The y-axis will be the answer option which used to shown its value.

	= The following steps show you how to create the above diagram<br> =		= The following steps show you how to create the above diagram<br> =
Line 7:		Line 7:
	'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>  '''1. Open the Time set list (Tools/ Administrator / Report/ Time sets).<br><br>      [[Image:Diagram 3 1.JPG]] '''		'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>  '''1. Open the Time set list (Tools/ Administrator / Report/ Time sets).<br><br>      [[Image:Diagram 3 1.JPG]] '''

	'''<br>''' '''2. Create a new Time set: <br>'''   <br>    [[Image:~~Diagram_3_3~~.JPG]]		'''<br>''' '''2. Create a new Time set: <br>'''   <br>    [[Image:Diagram 3 3.JPG]]

	<br>		<br>

	- The new Time set is used to define the period of time. <br>     - ~~Data type~~: ~~Number <br> ~~  ~~  - Save numbers: 0,1,4 and null.~~<br>        ~~0: if the date of the EndDate column is in the same quarter of current date in the system.~~<br>      ~~  1:~~ if ~~the date of the EndDate column is in the previous quarter of current date in the system.<br>   ~~     4: if ~~the date of the EndDate column is in the same~~ quarter ~~but in the last year of current date in the system~~.~~<br>        Null: if the date of the EndDate column is in other quarters.<br>~~ '''3. Save this time set'''		- The new Time set is used to define the period of time. <br>     - Type: Month  <br>     - Label format : select type likes "Sep 2009"<br>     - Span : select 6 if user want to show value each 6 months, or select Span = 3 if user want to show value each quarter.

			'''3. Save this time set'''

	<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>  1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<br>'''        [[Image:Dash 1.JPG]]'''		<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>  1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<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 be added the DCS which is used to make Cross diagram.<br> '''4. Layout tab: '''Create Dashboard items<br>  '''4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>'''          [[Image:~~D_3_5~~.JPG]]		'''<br> 2. Create a new dashboard or edit an existing one.''' <br> '''3. In General Information tab: '''Data caches list must be added the DCS which is used to make Cross diagram.<br> '''4. Layout tab: '''Create Dashboard items<br>  '''4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>'''          [[Image:D 3 5.JPG]]

			<br>     o Data cache: use the DCS which is used to make Cross diagram.<br>     o Time set : select the Time set which is created at step 1.

			o Column : select EndDate

			o Start date : select the 1st of June.


	~~<br>     o Data cache: use the DCS which is used to make Cross diagram.<br>     o This DB item will be used as the x-axis of the cross diagram.~~

	~~<br>~~   '''4.2 Create Dashboard (DB) item 2 whose type is Shown axis'''<br>          [[Image:Dash 2.JPG]]		'''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 used to make Cross diagram.		<br>     o Data cache : use the DCS which is used to make Cross diagram.

Catglobe at 06:46, 10 September 2009

2009-09-10T06:46:49Z

← Older revision		Revision as of 07:28, 10 September 2009
Line 13:		Line 13:
	<br>		<br>

	- A new Custom column is used to define the ~~year which this record is related to~~.<br>           - Data type : Number <br>           - Save numbers : 0,1 and null.<br>                 0 : if the ~~year~~ of the EndDate column is the same with the current ~~year~~ in the system.		- A new Custom column is used to define the quarters.<br>           - Data type : Number <br>           - Save numbers : 0,1,4 and null.<br>                 0 : if the date of the EndDate column is the same quarter with the current date in the system.

	1 : if the ~~year~~ of the EndDate column is in the previous ~~year~~ of current ~~year~~ in the system.<br>                 4 : if the ~~year~~ of the EndDate column is in the ~~previous~~ year of current ~~year~~ in the system.<br>                 Null : if the ~~year~~ of the EndDate column is in other ~~years~~.		1 : if the date of the EndDate column is in the previous quarter of current date in the system.<br>                 4 : if the date of the EndDate column is in the same quarter but in last year of current date in the system.<br>                 Null : if the date of the EndDate column is in other quarters.

	'''2.2 Put the CGScript which defines Current Year and Last Year'''<br><span id="fck_dom_range_temp_1251961601465_789">         [[Image:Insert script.JPG\|693x230px]]</span>		'''2.2 Put the CGScript which defines Current Year and Last Year'''<br><span id="fck_dom_range_temp_1251961601465_789">         [[Image:Insert script.JPG\|693x230px]]</span>

	- Input Name of the Custom column, this name will be an option of the axis set.<br>- Insert the CGSript.		- Input Name of the Custom column, this name will be an option of the axis set.<br>- Insert the CGSript.      <br>



	<br>

	{\| style="width: 634px; height: 296px" border="1" cellspacing="1" cellpadding="1" width="634"		{\| style="width: 634px; height: 296px" border="1" cellspacing="1" cellpadding="1" width="634"
Line 90:		Line 86:
	\|}		\|}

	~~<br>~~- 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> '''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>		<br>
Line 108:		Line 104:
	'''<u>Step 2. </u>Create Dashboard item whose type is Cross diagram.'''<br> '''1. Go to Dashboard list '''(Tools/ Reports/ Dashboard).<br>         [[Image:Dash 1.JPG]]		'''<u>Step 2. </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.<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]]		'''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.<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 4 options:		<br>         o Data cache: use the DCS which is created at step 1.<br>         o This DB item will be used as the X-axis of the cross diagram that has 4 options: Custom Service, Product, Web site and Brand.

	<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.<br>         o This DB item will be used as Y-axis of the cross diagram that has 3 options: Same Quarter Last Year, This Quarter and Last Quarter.

	<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.<br>         o Chart type: Bar<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.

	'''<br> '''<br>		'''<br> '''<br>

← Older revision		Revision as of 06:46, 10 September 2009
Line 1:		Line 1:
	[[Image:Diagram 3.JPG]] <span id="fck_dom_range_temp_1252565107133_175" /><span id="fck_dom_range_temp_1252565107133_224" />		[[Image:Diagram 3.JPG]] <span id="fck_dom_range_temp_1252565107133_175" /><span id="fck_dom_range_temp_1252565107133_224" />

	The diagram above is a cross diagram which is made by crossing 2 axes together:<br>- The x-axis has 4 options: Custom Service, Product, Web site and Brand.<br>- The y-axis has 3 options: Same Quarter Last Year, Last Quarter and This Quarter. Calculations for these options are based on values stored in a custom column in the data cache. These values, which are calculated on corresponding values in the EndDate column, indicate whether an RPQ was finished in this quarter, last quarter, or the same quarter last year.		The diagram above is a cross diagram which is made by crossing 2 axes together:<br>- The x-axis has 4 options: Custom Service, Product, Web site and Brand.<br>- The y-axis has 3 options: Same Quarter Last Year, Last Quarter and This Quarter. Calculations for these options are based on values stored in a custom column in the data cache. These values, which are calculated on corresponding values in the EndDate column, indicate whether an RPQ was finished in this quarter, last quarter, or the same quarter last year.
Line 7:		Line 7:
	'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>  '''1. Open the Time set list (Tools/ Administrator / Report/ Time sets).<br><br>      [[Image:Diagram 3 1.JPG]] '''		'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>  '''1. Open the Time set list (Tools/ Administrator / Report/ Time sets).<br><br>      [[Image:Diagram 3 1.JPG]] '''

	'''<br>''' '''2. Create a new Time set: <br>'''   <br>    [[Image:~~Add custom~~.JPG]]		'''<br>''' '''2. Create a new Time set: <br>'''   <br>    [[Image:Diagram_3_3.JPG]]

	<br>		<br>
Line 15:		Line 15:
	<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>  1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<br>'''        [[Image:Dash 1.JPG]]'''		<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>  1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<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 be added the DCS which is used to make Cross diagram.<br> '''4. Layout tab: '''Create Dashboard items<br>  '''4.1 Create Dashboard (DB) item 1 whose type is Time set. <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 be added the DCS which is used to make Cross diagram.<br> '''4. Layout tab: '''Create Dashboard items<br>  '''4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>'''          [[Image:D_3_5.JPG]]

	<br>     o Data cache: use the DCS which is used to make Cross diagram.<br>     o This DB item will be used as the x-axis of the cross diagram.		<br>     o Data cache: use the DCS which is used to make Cross diagram.<br>     o This DB item will be used as the x-axis of the cross diagram.
Line 21:		Line 21:
	<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 used to make Cross diagram.		<br>     o Data cache : use the DCS which is used to make Cross diagram.

	o This DB item will be used as the y-axis of the cross diagram.		o This DB item will be used as the y-axis of the cross diagram.

	<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 used to make diagram.		<br>     o Data cache: use the DCS which is used to make diagram.

	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 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.'''