Page and Portlet Configuration › How to Configure Time-Scaled Values › Configure Column Settings

Configure Column Settings

This procedure explains how to configure column settings for time-sliced values in a single column in a list display.

To configure column settings for time-sliced values

1. From a portlet that contains time-scaled values, choose Configure from the Actions drop-down.

   The Configure: List Column Layout page appears.

2. Click Fields in the content menu.

   The Configure: List Column Fields page appears. Select “All” from the Display drop-down, then edit the labels of the columns you want to update.

3. Click the Properties icon in the row that represents the column you want to configure.

   The column represented by the row must have a Display Type of "Time Scaled Value".

   The Time Scaled Value Column Settings page appears.

4. Change the following settings as desired in the General section:

   Value Attributes

   Select the primary values you want to display in the time period cells.

   Column Label

   Enter the label you want to display above the time scale column.

   Display Type

   Select Number, Bar Graph, or Column Graph from the drop down list.

   Decimal Places

   Select the number of decimal places you want to use in numeric displays. The default is two.

   Allow Word Wrapping in Column Header

   Select this field to allow words to automatically wrap in the column header.

   Secondary Value

   If you want to display stacked data in the column cells, choose a secondary value to appear with the column data.

   Link

   You can make the data in the column work as a link to another related page. The relevant, related pages are listed in this field for you to select.

   Allow Editing

   Select this check box to enable edit mode (from the Actions menu) and allow editing of the values that display in the column.

   Show Legend Column

   Select this check box to label the individual values that display stacked in the column.

   Show Column Label

   Select this check box to label the virtual column that displays time-sliced values.

5. Change the following settings as desired in the Time Scale section:

   Start Date

   Specifies the type of start date that begins the column spread. You can select a particular date, or a rolling date such as Start of Previous Month.

   Time Scale

   Specifies the time period (e.g. weekly, monthly, quarterly, and so on) by which data displays.

   Number of Time Periods

   Defines the number of time periods you want to see displayed.

   Time Period Offset

   Use this field to shift the first time period in the graph by a positive or negative number of weeks or months (or whatever time period you select).

   Show Group Header Row

   Select the check box and select the Year, Quarter, Semi-Month, Month, or Week (if you want to display a time scale above a Gantt bar).

6. Click Submit.