Diagram 2

The diagram above is a cross diagram which is made by crossing 2 axes together:
- The X-axis has 12 options: Jan, Feb, Mar, … Dec
- The Y- axis has 2 options: This Year and Last Year. 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 year or last year.

The following steps show you how to create the above diagram

Step 1. Create a new axis set in DCS list based on the EndDate column
 1. Open the Data Cache in Data Cache list (Tools/Data/Data Caches).
 2. In the Data Cache tab 
   2.1 Select Column’s type then click “Add Column” button to insert a new Custom column
 

- A new Custom column is used to define the Quarter which this record is related to the current day in the system.
- Data type : Number
- Save numbers : 0,1 and null.
   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.
   Null : if the year of the EndDate column is in other years.

   2.2 Put the CGScript which defines Current Year and Last Year