Adding a Constant Value Column to a Measures Portlet

  1. Browse to the page that contains the portlet that you want to edit.

  2. On the DivePort toolbar, click Edit to unlock the page and enable edit mode.

  3. Right-click the measures portlet that you want to edit, and then on the context menu, click Edit.

    The Edit Measures Portlet wizard opens.

  4. In the Columns Closedbox, click Add, and then in the context menu, click Text Columns.

    Sample Edt Measures Portlet page.

    The wizard advances to the Select values page.

  5. Select Constant value, and then click Next.

    The wizard advances to the next page.

  6. In the Value Closedbox, enter the value or macro that you want to display on every row.

    Constant value setting

    NOTE: The Title, Size, and Overflow options are not available for constant value columns.

  7. If you want to color the value text, click the Edit this threshold Closedicon to the right of the Any value item in the Colors box, and use the color picker to select a color.

    Edit threshold color.

  8. Click OK.

    Notice that the new column is added to the column list. The green A indicates that it is a constant value column, and the word blank indicates that there is no column title.

  9. Click OK.
  10. On the toolbar, click Save to save your changes and exit edit mode.

You can use constant values to produce the effect of labeling stacked column values

The following example shows a measures portlet with two stacked columns. The third column in the portlet shows Cost and Cases as constant values in each row. The forth column shows specific values that uniquely apply to that row.

Sample measures portlet

The portlet columns in the example are defined as follows:

Edit Measures Portlet page.