Previous Topic: Open the Configuration OptionsNext Topic: How to Configure a Chart


How to Configure a List

You can complete the following tasks to personalize a list portlet:

Set List Column Layout

Follow these steps:

  1. Open the Options menu and click Configure.

    The configuration window appears with the list column layout displayed.

  2. In the Column Layout section, select columns to include in the portlet by highlighting the columns in the Available Columns list and clicking the right arrow to add them to the Selected Columns list.

    You can use the up and down arrows to place the selected columns in the desired order.

  3. Complete the following actions in the Column Sorting section:
    1. Select the order in which columns are sorted by selecting the appropriate field in each column drop-down list.
    2. Click Ascending or Descending to determine how data is sorted within each column.

    Note: Column sorting is not available for hierarchical list pages.

  4. Save the changes.

More information:

How to Configure a List

Set List Options

View and Edit List Portlet Fields

Set List Options

Follow these steps:

  1. Open the Options menu and click Configure.

    The configuration window appears with the list column layout displayed.

  2. Open the List Column Section menu, and click Options
  3. Complete the following fields:
    Secondary Value Display

    Indicates the way that secondary values display in a grid cell.

    Values:

    • Mouseover only. This method specifies no secondary value display.
    • Mouseover and redline text. This method specifies the display of a secondary, comparison value when you place the cursor over a cell in a grid. For example, if you have two columns named Cost and Baseline Cost, you can display both values in a cell. To display both, select Baseline Cost as the secondary value. The Cost value displays as usual. However, when you move the cursor over a cell in the grid, the Baseline Cost also displays.
    • Show Null Secondary Values. This method specifies that the secondary value displays even when there is no number value to show.
    Rows per Page

    Specifies the number of rows to display per page.

    Filter

    Indicates how the results appear initially on a page.

    Highlight Row by Attribute

    Specifies the attribute whose row is highlighted when the attribute value is not zero.

    Display Currency Code in Column

    Specifies whether to display the currency code in the column for money attributes.

    Allow Configuration

    Indicates that users can modify the appearance of a portlet.

    Allow Label Configuration

    Indicates that users can modify portlet labels.

  4. Save the changes.

More information:

How to Configure a List

Set List Column Layout

View and Edit List Portlet Fields

Add a Gantt Chart to a List Portlet

A Gantt chart is a virtual field that shows duration and progress over time. New virtual fields are automatically displayed in the far right column of the list. You can move the field to a different position in the List Column layout.

Follow these steps:

  1. Open the List Column Section menu, and click Fields.

    The list column fields page appears.

  2. Click New.

    The create page appears.

  3. Select Gantt, and click Save and Continue.

    The column settings page appears.

  4. Complete the following fields in the General section:
    Column Label

    Defines the name that appears at the top of the column.

    Show Column Label

    Indicates whether the column label appears at the top of the column list.

    Allow Word Wrapping in Column Header

    Indicates whether the text in the column label wraps within the column.

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

    Indicates the start date for the Gantt chart. Do one of the following:

    • Select Specific Date and enter a date or click the Datepicker icon and select a date from the calendar that appears.
    • Select Rolling Date and select a relative date from the drop-down list.
    Time Scale

    Specifies the time values to show across the top of the Gantt chart. Select a value from the drop-down list.

    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 Gantt bar 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 Primary Bar section:
    Item Name Attribute

    Specifies the field name for the primary bar of the Gantt chart. Select a field from the drop-down list.

    Start Date Attribute

    Specifies the date field value to use at the beginning of the Gantt bar. Select a field from the drop-down list.

    Finish Date Attribute

    Specifies the date field value to use at the end of the Gantt bar. Select a field from the drop-down list.

    Milestone Attribute

    Specifies the field value to use as a milestone. Select a field from the drop-down list. If the field contains a non-zero value, the Gantt chart displays a diamond.

    Progress Through Date Attribute

    Specifies the date field value to use to indicate when work is complete. Select a field from the drop-down list. If you choose a Progress Through Date Attribute value, the value chosen overrides the Progress Percent Attribute.

    Show Mouseover

    Indicates the values that appear when a user moves a cursor over the bar. Select the check boxes of the items listed that you want to appear.

  7. In the Show Dates on Primary Bar section, select the dates you want to show on the primary Gantt bar in the Available list and click the right arrow key to move the dates to the Selected list.
  8. (Optional) To display a second bar below the primary bar for comparison purposes, select the Show Secondary Bar check box and complete the fields in the section.
  9. Save the changes.

More information:

How to Configure a List

Set List Column Layout

Set List Options

Configure Gantt Chart Display Settings

Gantt charts appear on various pages throughout CA Clarity PPM. The steps to change the display settings are the same from any page with a Gantt chart.

By default, Gantt charts display only one bar, the primary bar. You can change the information displayed in that bar (Total Effort, by default). You can also add a secondary bar to display complimentary or contrasting data. You can also change the time configurations that display in the chart.

Follow these steps:

  1. From a page that contains a Gantt chart, open the Options menu and click Configure.

    The list column layout page appears.

  2. Open the List Column Section menu, and click Fields.

    The list column fields page appears.

  3. Click the Properties icon next to the Gantt chart column label (for example, the Gantt chart column label can be "Schedule").

    The Gantt chart column settings page appears.

  4. Change the following field in the General section:
    Column Label

    Defines the name for the main column header, which spans multiple columns.

    Default: Schedule

    Show Column Label

    Indicates if the name of the column displays on the page or portlet.

    Default: Selected

    Allow Word Wrapping in Column Header

    Indicates whether you want text in the column label to wrap.

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

    Indicates the start date for the column spread.

    Time Scale

    Specifies the time period by which data displays (days, weeks, and so on).

    Number of Time Periods

    Defines the number of time periods that display.

    Time Period Offset

    Defines how to shift the beginning of the Gantt bar relative to the start date. Enter a positive or negative number of time periods into the field.

    Show Group Header Row

    Indicates whether the timescale displays above the Gantt bar. If you select this option, select a timescale value.

  6. Change the following fields in the Primary Bar section:
    Item Name Attribute

    Defines the type of information to display in the corresponding Gantt bar.

    Start Date Attribute

    Defines the start date of the corresponding Gantt bar display.

    Finish Date Attribute

    Defines the finish date of the corresponding Gantt bar display.

    Milestone Attribute

    Defines the attribute to designate as a milestone. You can only assign a milestone attribute for a task.

    Progress Through Date Attribute

    Specifies the attribute used to move the green progress line relative to the length of the task bar to indicate the work completed for the task.

    Progress Percent Attribute

    Defines the percentage that is used to move the green progress line relative to the length of the taskbar to indicate the completed work. If you select a value for this field, it overrides the Progress Through Date Attribute selection.

    Label for Bar

    Specifies the label text to display above each taskbar.

    Additional Information Attribute

    Specifies the field used in the text note when you hover over a taskbar. For example, to display the assigned resources for a task, when the cursor is over a taskbar, complete the following steps:

    • Select Assigned Resources from the Additional Information Attribute field.

    Select Additional Information in the Show Mouseover field.

    Show Mouseover

    Specifies the information that you want to display in a text note when the mouse scrolls over an area of the Gantt chart.

  7. Indicate the dates to show in the primary bar when you select the desired dates in the Available section. Click the right arrow to add the dates to the Selected section. You can reorder the dates in the list.
  8. Change the following Secondary Bar settings for the Gantt chart to display a secondary bar:
    Show Secondary Bar

    Indicates if the chart displays a second bar below the primary bar.

    Item Name Attribute

    Defines the type of information to display in the corresponding Gantt bar.

    Start Date Attribute

    Defines the start date of the corresponding Gantt bar display.

    Finish Date Attribute

    Defines the finish date of the corresponding Gantt bar display.

    Progress Through Date Attribute

    Specifies the attribute used to move the green progress line relative to the length of the task bar to indicate the work completed for the task.

    Progress Percent Attribute

    Defines the percentage that is used to move the green progress line relative to the length of the taskbar to indicate the completed work. If you select a value for this field, it overrides the Progress Through Date Attribute selection.

    Show Mouseover

    Specifies the information that you want to display in a text note when the mouse scrolls over an area of the Gantt chart.

  9. Save the changes.

More information:

How to Configure a List

Modify Time Period Settings for a Gantt Chart

You can change the Gantt chart timescale to zoom in and out of the timeline. For example, if you are viewing the monthly timeline, to zoom in to see daily timeline information, select the Days timescale value from the Calendar drop-down at the top of the Gantt chart.

Follow these steps:

  1. From a page that contains the Gantt chart, open the Options menu and click Gantt.

    The time period settings page appears.

  2. Modify the following fields:
    Start Date

    Indicates the start date for the column spread.

    Time Scale

    Specifies the time period by which data displays (days, weeks, and so on).

    Number of Time Periods

    Defines the number of time periods that display.

    Time Period Offset

    Defines how to shift the beginning of the Gantt bar relative to the start date. Enter a positive or negative number of time periods into the field.

  3. Save the changes and close.

View and Edit List Portlet Fields

You can view and edit the fields that display for a list portlet.

Follow these steps:

  1. Open the List Column Section, and click Fields.

    The list column fields page appears.

  2. Use the Show and Display fields to control what you see in the list by selecting columns, or a combination of both, select the correct option, and click Go.
  3. To make changes to how a field displays, click the Properties icon located next to the field.
  4. To change a field label, enter a new value in the Column Label field.
  5. Save the changes.

More information:

How to Configure a List

Set List Column Layout

Set List Options

Add an Image to a List Portlet

You can add an image that links to another page. New virtual attributes like an image are automatically displayed in the far right column of the list. You can move the virtual attribute to a different position in the List Column layout.

Follow these steps:

  1. Open the List Column Section menu, and click Fields.

    The list column fields page appears.

  2. Click New.

    The create page appears.

  3. Select Image, and click Save and Continue.

    The column settings page appears.

  4. Complete the following fields in the General section:
    Column Label

    Defines the name that appears at the top of the column.

    Show Column Label

    Indicates whether the column label appears at the top of the column list.

    Allow Word Wrapping in Column Header

    Indicates whether the text in the column label wraps within the column.

    Image

    Specifies the image to use in the grid column.

    Link

    Specifies a page link that appears as a secondary value that the user can select.

    Open as Pop-up

    Indicates whether the target page of the image link appears as a pop-up.

  5. Save the changes.

More information:

How to Configure a List

Set List Column Layout

Set List Options

View and Edit List Portlet Fields

Add a Progress Bar to a List Portlet

A progress bar shows progress over time. New virtual attributes like the progress bar are automatically displayed in the far right column of the list. You can move the virtual attribute to a different position in the List Column layout.

Follow these steps:

  1. Open the List Column Section menu, and click Fields.

    The list column fields page appears.

  2. Click New.

    The create page appears.

  3. Select Progress Bar, and click Save and Continue.

    The column settings page appears.

  4. Complete the following fields in the General section:
    Column Label

    Defines the name that appears at the top of the column.

    Show Column Label

    Indicates whether the column label appears at the top of the column list.

    Allow Word Wrapping in Column Header

    Indicates whether the text in the column label wraps within the column.

    Current Stage Name

    Specifies the field value to use for each stage in the progress bar. The value displays below the column label.

    Current Stage Number

    Specifies the field value to use for the current stage in the progress bar.

    Number of Stages

    Specifies the field value that defines the total number of stages in the progress bar.

    Color Attribute

    Specifies the color of the progress bar.

    Show Label

    Indicates whether the name of the current stage is displayed in the progress bar.

    Column Width

    Defines the percentage of the grid portlet that the virtual column is to occupy.

  5. Save the changes.

More information:

How to Configure a List

Set List Column Layout

Set List Options

View and Edit List Portlet Fields

Add a Time-Scaled Value to a List Portlet

A time-scaled value field is one that you can set up on a list 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. 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 list 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.

New virtual attributes such as a time-scaled value are automatically displayed in the far right column of the list. You can move the virtual attribute to a different position in the List Column layout.

Follow these steps:

  1. Open the List Column Section menu, and click Fields.

    The list column fields page appears.

  2. Click New.

    The create page appears.

  3. Select Time Scaled Value, and click Save and Continue.

    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.

    Display Type

    Specifies how the time-scaled value is to display: as a number, a column graph, or a bar graph.

    Secondary Value

    Specifies an additional (second) value for a time-scaled value virtual column that displays as a tooltip 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.

    Open as Pop-up

    Indicates whether the target page of the image link appears 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.

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

    Indicates the start date for time period for the virtual-scaled value.

    Values:

    • Specific Date. Click the Datepicker icon to select a date.
    • Rolling Date. Click the down arrow to select a relative date.
    • Other Date. This option appears only if you are selecting a start date for a time-scaled value for a subobject. This field allows you to select a field from the master object on which to base the start date. This option only appears when a subobject has time-scaled value attributes.
    Time Scale

    Specifies the length of time the time-scaled value covers.

    Values:

    • Specific Time 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.
    • Other Time Scale. 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

    Defines the number of time periods that will be reported in the virtual column.

    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

    Specifies a timescale is to be displayed above the virtual column. Select the check box to display a timescale and select the period type you want from the drop-down list.

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

    Defines the number of decimal places to return for the attribute. To specify the attribute as an integer, enter a zero (0).

    Alignment

    Specifies the text alignment in grid cells.

    Allow Word Wrapping in Column Header

    Indicates whether the text in the column label wraps within the column.

    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. Save the changes.

More information:

How to Configure a List

Set List Column Layout

Set List Options

View and Edit List Portlet Fields

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

An aggregation row shows statistical data for money or number fields that display in the aggregation row. You can choose from a number of mathematical functions to apply to the individual fields you select for the row. You can choose maximum, minimum, average, sum, count, standard deviation, and variance.

Follow these steps:

  1. Open the List Column Section menu, and click Aggregation.

    The list aggregation page appears.

  2. Click Add.

    The properties page appears.

  3. Complete the following fields:
    Label

    Defines the name for the aggregation row. Enter the name you want to appear.

    Show

    Determines whether the name of the aggregation row is displayed. Select the check box to display the name.

    Attribute

    Specifies the field value that is to be used for aggregation. All fields that you have selected for the grid portlet are present for selection but do not have to be included in the aggregation row.

    Function

    Specifies the aggregation function used to calculate values for a selected field (cell) in the row.

  4. Save the changes.

More information:

How to Configure a List

Display an Aggregation Field as a Bar or Column Graph

Display an Aggregation Field as a Bar or Column Graph

You can display a field in an aggregation row as a number, a bar graph or a column graph. By default, the field displays as a number when it is first added to the aggregation row. The following procedure describes how to display an aggregation field as a bar or column graph.

This procedure assumes that the aggregation row with number fields has been created.

Follow these steps:

  1. Open the List Column Section menu, and click Aggregation.

    The list aggregation page appears.

  2. In the Display row, click the word that appears below the column whose display you want to change.

    The display page appears.

  3. Select the display type, and click Save and Continue.

    If you select bar or column graph, these words appear at the bottom of the column in the Display row.

  4. To complete the setup for a bar or column graph, click Bar Graph or Column Graph in the Display Row to complete the additional fields
  5. Complete the following fields in the Primary Column section:
    Thickness

    Specifies the thickness of the column.

    Values:

    • Autofit
    • Narrow
    • Medium
    • Wide
    Maximum Length

    Defines the maximum length that the graph can be as a column or bar in pixels.

    Length Scaling

    Specifies what will be used as the basis for scaling if you want the graph scaled.

    Color

    Specifies the color for the graph.

    Threshold Line Attribute

    Specifies the field that is to be used to calculate a threshold for the graph.

    Threshold Aggregation Function

    Specifies the mathematical function used to calculate a threshold for the graph.

    Over-threshold Color

    Specifies the graph color used to indicate when the threshold has been exceeded.

  6. To stack a second aggregation field value in the column of the list portlet, complete the following fields in the Stacked Column section:
    Stacked Attribute

    Specifies the second field value to be displayed as a bar or column graph in a column.

    Color

    Specifies the color for the graph.

  7. Save the changes.