Diagram 3 - Revision history

Catglobe at 08:00, 10 September 2009

2009-09-10T08:00:26Z

← Older revision		Revision as of 08:00, 10 September 2009
Line 7:		Line 7:
	<u>'''Step 1.'''</u>'''Create a new time set in Time set list.'''		<u>'''Step 1.'''</u>'''Create a new time set in Time set list.'''

	'''     1. Open the Time set list (Tools/ Administration / Report/ Time sets).'''		'''     1. Open the Time set list (Tools/ Administration / Report/ Time sets).'''

	[[Image:Diagram 3 1.JPG]] .		[[Image:Diagram 3 1.JPG]] .
Line 19:		Line 19:
	- 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 the Time set.'''		'''   3. Save the Time set.'''

	'''<u>Step 2. </u>Create Dashboard item whose type is Cross diagram.'''		'''<u>Step 2. </u>Create Dashboard item whose type is Cross diagram.'''
Line 39:		Line 39:
	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 used to make diagram.		<br>         o Data cache: use the DCS which is used to make diagram.

	o Chart type: Line		o Chart type: Line

Catglobe at 07:58, 10 September 2009

2009-09-10T07:58:01Z

← Older revision		Revision as of 07:58, 10 September 2009
Line 7:		Line 7:
	<u>'''Step 1.'''</u>'''Create a new time set in Time set list.'''		<u>'''Step 1.'''</u>'''Create a new time set in Time set list.'''

	'''1. Open the Time set list (Tools/ Administration / Report/ Time sets).'''     ~~       [[Image:Diagram_3_1.JPG]] .~~		'''     1. Open the Time set list (Tools/ Administration / Report/ Time sets).'''

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

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

			[[Image:Diagram 3 3.JPG]]

	<br>		<br>
Line 21:		Line 23:
	'''<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. '''
Line 29:		Line 31:
	'''4. Layout tab''': Create Dashboard items.		'''4. Layout tab''': Create Dashboard items.

	4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>         [[Image:~~D_3_5~~.JPG]]		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 Column : select EndDate <br>          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]]		<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 Column : select EndDate <br>          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]]

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

	o Chart type: Line		o Chart type: Line

Catglobe at 07:55, 10 September 2009

2009-09-10T07:55:59Z

Catglobe at 07:55, 10 September 2009

2009-09-10T07:55:15Z

Show changes

Catglobe: Created page with 'Image:Diagram 3.JPG The diagram above is a cross diagram which is made by crossing 2 axes together:
- The x-axis will be used a time set.
- The y-axis will be the ans…'

2009-09-10T07:52:05Z

Created page with 'Image:Diagram 3.JPG The diagram above is a cross diagram which is made by crossing 2 axes together: - The x-axis will be used a time set. - The y-axis will be the ans…'

New page

[[Image:Diagram 3.JPG]]

The diagram above is a cross diagram which is made by crossing 2 axes together: - The x-axis will be used a time set. - 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 =

'''Step 1.''''''Create a new time set in Time set list.''' 

'''1. Open the Data Cache in Data Cache list''' (Tools/Data/Data Caches)            [[Image:Dash 0.JPG]] .

 ''' 2. In the Data Cache tab:''' 

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

 

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

           - Data type : Number 

           - 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

                 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'''          [[Image:Insert script.JPG|693x230px]] 

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

- Insert the CGSript.       

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

array today = getDateTime();

number todayYear = today[DateTime_Year];

number todayMonth = today[DateTime_Month];

number TodayQuarter = 1;

number endDateQuarter = 1;

number IsLastQuarter = 1;

number IsThisQuarter = 0;

number IsSameQuarterLastYear = 4;

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

TodayQuarter = 1;

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

TodayQuarter = 2;

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

TodayQuarter = 3;

else TodayQuarter = 4;

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

endDateQuarter = 1;

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

endDateQuarter = 2;

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

endDateQuarter = 3;

else endDateQuarter = 4;

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

return IsThisQuarter;

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

return IsLastQuarter;

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

return IsSameQuarterLastYear;

//End Script

|}

- Save the Custom column.

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

'''''       '''3.1 Create a new axis set        ''''''[[Image:Create new axis.JPG|269x392px]]''' 

 

  ''3.2 Input value to the new axis set''

'''         [[Image:Input value.JPG]]''' 

       Axis math – base, Axis pct – base, Option value : will be used the Custom column’s name.

       For example : 

     [[Image:Example.JPG|696x323px]] 

  '''4. Save the Data cache.'''

'''Step 2. Create Dashboard item whose type is Cross diagram.'''  

'''     1. Go to Dashboard list '''(Tools/ Reports/ Dashboard).          [[Image:Dash 1.JPG]] 

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

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

      4.1 Create Dashboard (DB) item 1 whose type is Shown axis.           [[Image:Dash 2.JPG]]

          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. 

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

          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.

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

          o Data cache: use the DCS which is created at step 1.

         o Chart type: Bar

         o X – axis: must be DB item 4.1

         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 Data format: absolute

         o Direction: Vertical

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

// Finish creating the diagram.

← Older revision		Revision as of 07:55, 10 September 2009
Line 7:		Line 7:
	<u>'''Step 1.'''</u>'''Create a new time set in Time set list.'''		<u>'''Step 1.'''</u>'''Create a new time set in Time set list.'''

	'''1. Open the Time set list (Tools/ Administration / Report/ Time sets).'''		'''1. Open the Time set list (Tools/ Administration / Report/ Time sets).'''            [[Image:Diagram_3_1.JPG]] .
	[[Image:~~Dash 0~~.JPG]] .

	<br>''' 2. Create a new Time set :'''		<br>''' 2. Create a new Time set :'''

	[[Image:~~Add custom~~.JPG]]		[[Image:Diagram_3_3.JPG]]

	<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 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 the Time set.'''		'''3''''''. Save the Time set.'''
Line 26:		Line 25:
	'''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 used to make Cross diagram.		'''   3. In General Information tab''': Data caches list must have the DCS which is used to make Cross diagram.

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

	4.1 Create Dashboard (DB) item 1 whose type is Time set. <br>         [[Image:~~Dash 2~~.JPG]]		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 Column : select EndDate <br>          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]]		<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 Column : select EndDate <br>          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]]

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

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

Diagram 3 - Revision history

Catglobe at 08:00, 10 September 2009

Catglobe at 07:58, 10 September 2009

Catglobe at 07:55, 10 September 2009

Catglobe at 07:55, 10 September 2009

Catglobe: Created page with 'Image:Diagram 3.JPG The diagram above is a cross diagram which is made by crossing 2 axes together:- The x-axis will be used a time set.- The y-axis will be the ans…'

Catglobe: Created page with 'Image:Diagram 3.JPG The diagram above is a cross diagram which is made by crossing 2 axes together:
- The x-axis will be used a time set.
- The y-axis will be the ans…'