Add Matrix Column

To display time-series matrix-transformed data in a sheet, a type of column called a "matrix column" should be added to the sheet. To add a matrix column, follow the steps below.

1. Select "Add Columns" from column header menu.

2. Click "Time-series Matrix Column" tab in the column setting dialog.

3. [A] Child Relation Object - Select a related list which you want to apply time-series matrix transformation.

   • Only related lists placed in the default page layout of the object will be listed in the "Child Relation Object" pulldown.

4. [B] Series Field - Select a field that will be the axis of time-series matrix transformation.

   • Currently only date type fields can be selected as Series Field.

5. [C] Interval - Specify the display interval of time series field. Choose from the following values:

   • Yearly

   • Quarterly

   • Monthly

   • Weekly

   • Daily

6. [D] Start - Specify the start date of time series value.

7. [E] Duration - Specify the duration of the time series in number, which must be an integer greater than or equal to 1.

8. [F] Column Field - Select fields from related list object which will be displayed inside of matrix column. If you click [G] Add Column Field link, you can add multiple fields at once.