Difference between revisions of "Diagram 1"

From Catglobe Wiki
Jump to: navigation, search
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&nbsp;will be used a time set.<br>- The y-axis&nbsp;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>&nbsp; '''1. Open the Time set list (Tools/ Administrator / Report/ Time sets).<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:Diagram 3 1.JPG]]&nbsp;'''  
 
'''<u>Step 1. </u>Create a new Time set in Time set list '''<br>&nbsp; '''1. Open the Time set list (Tools/ Administrator / Report/ Time sets).<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:Diagram 3 1.JPG]]&nbsp;'''  
  
'''<br>'''&nbsp;'''2.&nbsp;Create a new Time set:&nbsp;<br>'''&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp; [[Image:Diagram_3_3.JPG]]  
+
'''<br>'''&nbsp;'''2.&nbsp;Create a new Time set:&nbsp;<br>'''&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp; [[Image:Diagram 3 3.JPG]]  
  
 
<br>
 
<br>
  
&nbsp;&nbsp;&nbsp;&nbsp; - The new&nbsp;Time set is used to define the&nbsp;period of time.&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- Data type: Number <br>&nbsp;&nbsp;&nbsp;&nbsp; - Save numbers: 0,1,4 and null.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; 0: if the date of the EndDate column is in the same quarter of current date in the system.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1: if the date of the EndDate column is in the previous quarter of current date in the system.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Null: if the date of the EndDate column is in other quarters.<br>&nbsp;'''3.&nbsp;Save this time set'''&nbsp;&nbsp;  
+
&nbsp;&nbsp;&nbsp;&nbsp; - The new&nbsp;Time set is used to define the&nbsp;period of time.&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- Type:&nbsp;Month &nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;Label format :&nbsp;select type likes "Sep 2009"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- Span :&nbsp;select 6 if user want to&nbsp;show value each 6&nbsp;months, or&nbsp;select&nbsp;Span = 3 if user want to show value each quarter.
 +
 
 +
&nbsp;'''3.&nbsp;Save this time set'''&nbsp;&nbsp;  
  
 
<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>&nbsp;&nbsp;1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<br>'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:Dash 1.JPG]]'''  
 
<u>'''Step 2.'''</u>'''Create Dashboard item whose type is Cross diagram<br>&nbsp;&nbsp;1. Go to Dashboard list''' (Tools/ Reports/ Dashboards).<br>'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:Dash 1.JPG]]'''  
  
'''<br>&nbsp;2. Create a new dashboard or edit an existing one.'''&nbsp;<br>&nbsp;'''3. In General Information tab: '''Data caches list must be added the DCS which is&nbsp;used to make Cross diagram.<br>&nbsp;'''4. Layout tab: '''Create Dashboard items<br>&nbsp;&nbsp;'''4.1 Create Dashboard (DB) item 1 whose type is&nbsp;Time set.&nbsp;<br>'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:D_3_5.JPG]]&nbsp;  
+
'''<br>&nbsp;2. Create a new dashboard or edit an existing one.'''&nbsp;<br>&nbsp;'''3. In General Information tab: '''Data caches list must be added the DCS which is&nbsp;used to make Cross diagram.<br>&nbsp;'''4. Layout tab: '''Create Dashboard items<br>&nbsp;&nbsp;'''4.1 Create Dashboard (DB) item 1 whose type is&nbsp;Time set.&nbsp;<br>'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:D 3 5.JPG]]&nbsp;  
 +
 
 +
<br>&nbsp;&nbsp;&nbsp;&nbsp; o Data cache: use the DCS&nbsp;which is used to make Cross diagram.<br>&nbsp;&nbsp;&nbsp;&nbsp; o Time set : select the Time set which is created at step 1.
 +
 
 +
&nbsp;&nbsp;&nbsp;&nbsp; o Column : select EndDate
 +
 
 +
&nbsp;&nbsp;&nbsp;&nbsp; o&nbsp;Start date : select the 1st of June.
 +
 
  
<br>&nbsp;&nbsp;&nbsp;&nbsp; o Data cache: use the DCS&nbsp;which is used to make Cross diagram.<br>&nbsp;&nbsp;&nbsp;&nbsp; o This DB item will be used as the x-axis of the cross&nbsp;diagram.
 
  
<br>&nbsp;&nbsp; '''4.2 Create Dashboard (DB) item 2 whose type is Shown axis'''<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:Dash 2.JPG]]  
+
&nbsp;&nbsp; '''4.2 Create Dashboard (DB) item 2 whose type is Shown axis'''<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [[Image:Dash 2.JPG]]  
  
 
<br>&nbsp;&nbsp;&nbsp;&nbsp; o Data cache&nbsp;: use the DCS which is&nbsp;used to make Cross diagram.  
 
<br>&nbsp;&nbsp;&nbsp;&nbsp; o Data cache&nbsp;: use the DCS which is&nbsp;used to make Cross diagram.  

Revision as of 08:59, 10 September 2009

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 Time set list (Tools/ Administrator / Report/ Time sets).

      Diagram 3 1.JPG 


 2. Create a new Time set: 
   
    Diagram 3 3.JPG


     - The new Time set is used to define the period of time. 
     - Type: Month  
     - Label format : select type likes "Sep 2009"
     - 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  

Step 2.Create Dashboard item whose type is Cross diagram
  1. Go to Dashboard list
(Tools/ Reports/ Dashboards).
        Dash 1.JPG


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


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


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


     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.


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


     o Data cache: use the DCS which is used to make diagram.

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