Add a Time-Scaled Value to a Grid Portlet

A time-scaled value field is one that you can set up on a grid portlet that shows a value for a specific period of time. A time-scaled value is based on a time-varying attribute for which a user enters values in CA Clarity PPM. Note that as a user you cannot create a time-varying attribute. Only an administrator with the appropriate rights can create a time-varying attribute.

You can display multiple time-scaled values in a grid portlet. The data for the attributes displays as stacked on the page, with the information for each time-scaled value appearing in the same virtual column. The data that displays can be in units of money, numbers, or percentages.

CA Clarity PPM automatically displays new virtual attributes such as a time-scaled value in the far right column of the list. You can move the virtual attribute to a different position in the List Column layout.

To add a time-scaled value to a grid portlet

  1. With the grid portlet open, click Fields under the List Column Section content menu.

    The field page appears. Note that you can use the Show and Display fields to select the fields you want to see on the page.

  2. Click New.

    The create page appears.

  3. Select Time Scaled Value and click Submit.

    The column settings page appears.

  4. Complete the following fields in the General section:
    Value Attributes

    Indicates the time-scaled values that are to display in the virtual column. In the Available list box, select the attributes you want to list in the column and use the arrow buttons to move the attributes to the Selected list box.

    Column Label

    Defines the name that appears at the top of the column list in a grid portlet.

    Display Type

    Specifies how the time-scaled value is to display, as a number, a column graph, or a bar graph. Select the appropriate display option from the drop-down list box.

    Secondary Value

    Specifies an additional (second) value for a time-scaled value virtual column that can be displayed as a tooltip that displays when you mouse over the value in the column.

    Link

    Specifies a page link that appears as a secondary value that the user can select. Select a page from the drop-down list.

    Open as Pop-up

    Indicates whether the page appears as a pop-up. Select the check box to have the page appear as a pop-up.

    Show Legend Label

    Indicates whether the field label appears next to the time-scaled value in the virtual column. Select the check box to display the field label.

    Show Column Label

    Indicates whether the column label appears at the top of the column list. Select the check box to have the column label appear.

  5. Complete the following fields in the Time Scale section:
    Start Date

    Indicates the start date for time period for the virtual-scaled value. Select one of the following options:

    Specific Date. Click the Datepicker icon to chose a date.

    Rolling Date. Click the down arrow to select a relative date.

    Use Attribute. This option appears only if you are selecting a start date for a time-scaled value for a sub-object. The field allows you to select a field from the master object on which to base the start date.

    Time Scale

    Specifies the length of time the time-scaled value is to cover. Select one of the following options:

    Specific Scale. Indicates by naming a specific length of time what the period for the time-scaled value is. Click the down arrow to select a specific period of time.

    Use Attribute. This option appears only if you are selecting a time scale for a time-scaled value for a subobject. The field lets you select a field from the master object on which to base the time scale.

    Number of Time Periods

    Indicates the number of time periods to be displayed.

    Time Period Offset

    Defines the number of time periods you want to shift the beginning of the time-scaled value relative to the Start Date. You must enter a Start Date value to use this option.

    Show Group Row Header

    Indicates whether to print the time scale value used. Select the check box to show the value and select the value to be shown from the drop-down list.

  6. Complete the following fields in the Display section:
    Decimal Places

    Specifies the number of decimal places that can appear in number fields.

    Alignment

    Specifies the text alignment in grid cells.

    Allow Word Wrapping in Column Header

    Indicates whether the text in the column label can wrap within the column. Select the check box to allow wrapping.

    Allow Word Wrapping in Column

    Indicates whether the text in the column can wrap within the column. Select the check box to allow wrapping.

  7. Click Save.

More information:

Create a Grid Portlet

Determine a Grid Portlet's Columns and Layout

Add a Gantt Chart to a Grid Portlet

Add an Image to a Grid Portlet

Add a Progress Bar to a Grid Portlet

Add an Aggregation Row for a Number Field to a Grid Portlet