Measures Portlet Options

Available options depend on your license.

Standard License

Option	Description
Filename	Specifies the Spectre Dive, marker, or DiveBook file that provides the data for the portlet.
Change	Opens the Select Marker dialog box, which you can use to select a different data source file. NOTE: When you add a measures portlet to a page, the Select Marker dialog box opens automatically.
Fixed Columns	Specifies the number of columns, starting from the left, that are fixed in place if a horizontal scroll bar is needed. If any columns are stacked, this setting indicates the number of stacks, not actual columns.
	Opens the marker or Spectre Dive file in ProDiver directly from the Edit Measures Portlet dialog box.
	Opens the marker or Spectre Dive file in NetDiver directly from the Edit Measures Portlet dialog box.
	Opens the source file in Workbench directly from the Edit Measures Portlet dialog box.
Show Titles	Specifies that the column headings shown in the Column, Type, Stack table on this dialog box appear as column headings on the measures portlet display. This option is selected by default.
Show Totals	Specifies that the Totals row from the source data file displays on the portlet. This option is cleared by default. NOTE: This option is unavailable when columns are stacked.
Allow Sorting	Specifies that column sorting is enabled. The first time a measures portlet column is clicked, the data is sorted in one direction (ascending order for string columns; descending order for numeric columns). The next click to the same column reverses the sort. This option is selected by default.
Show Odd Row Coloring	Specifies that the row background color shifts for each row. Even rows default to the page background color (`windowBackgroundColor`) in the underlying skin. You can edit the following skin properties to control the coloring: Odd rows: `portletMeasuresOddRowColor` Even rows: `portletMeasuresEvenRowColor`
Blank Window Text	Enables you to enter a statement in the text box that displays when the window underlying the portlet is blank. The statement displays instead of standard error messages. You can use HTML and custom macros in this text box. Selecting the check box and leaving the text box blank makes the portlet invisible when the window is blank.
Allow Dimension Changing	Enables the user to change the dimension that appears on the portlet. This option is cleared by default. When enabled, a user can place the pointer on the dimension column heading to see a list of selectable dimensions and sort options.
Select Dimensions	Available when the Allow Dimension Changing check box is selected. Specifies the dimensions that can be displayed in the portlet. Click this option to open the Select Dimensions dialog box. To include all dimensions in the portlet, select Make all dimensions available. To include some of the dimensions, clear the Make all dimensions available check box. The window expands to list the available dimensions. Use the Ctrl+click (Windows) or Command-click (Mac) operation to select the dimensions that you want to include on your portlet, and then click OK.
Default Item Height	Defines the minimum row height, in pixels. The default, auto, is defined as 20. If the tallest item is shorter than or equal to the Default Item Height, the defined value is used. If the tallest item is taller than the Default Item Height, the row height adjusts to display the entire item.
Column, Type, Stack	Lists the data columns displayed in the measures portlet, their type, and a check box indicating if they are stacked with the preceding column. For information about stacking columns, see Stacking Columns in a Measures Portlet.
Add Text	Opens the Add Text Columns dialog box, which you can use to add columns to the measures portlet display. TIP: You can improve readability in Measures portlets by adding blank space between the columns. To achieve this, create a blank column by adding a text column where you want the space to be. Next, select it from the Edit Measures Portlet, Column list, and then in the Edit Text Column dialog box, delete the values in the Title and Values boxes, and set the Column Width to the size that you want the blank column to be. For example, 5px.
Add Indicator	Opens the Add an Indicator Column and Select an Indicator Type dialog boxes, which you can use to add an indicator or add row-scoped click actions to the measures portlet. For more information, see Adding an Indicator Column to a Portlet, and Indicator Portlet Options - Standard License
Edit	Available when a column is selected. Opens the Edit Text Column or Edit Indicator Column dialog box, which you can use to edit properties and add row-scoped click actions to the selected column. For more information, see Edit Text Column Options and Indicator Portlet Options - Standard License.
Remove	Available when a column is selected. Deletes the selected column.
Click Actions	Opens the Add Click Action dialog box, which you can use to add link-scoped click actions to the portlet. For more information, see Adding, Editing, or Removing a Click Action.

Edit Text Column Options

Example of a measure portlet, edit text column dialog box.

Option	Description
Title	Specifies a title for the column heading on the Measure instance. You can use DivePort macros for the title. If left blank, DivePort uses the column name defined in the marker, DiveBook, or Sprectre Dive file.
Value	Specifies the data column as defined in the marker, DiveBook, or Spectre Dive file.
Value Format	Specifies the format of the data value. The default, Auto, uses formatting specified in the source data. Select from options in the list or enter your own formatting. For more information, see Formatting Numeric Values. NOTE: Numeric data formatted as a date or time in a marker, Dive file, cPlan, or DivePlan retains that format when displayed in the measure instance.
Font	Specifies the font and size of the column text.
Color	Specifies the color of the column text.
Indentation	Specifies the size of the column text indentation, in pixels.
Justification	Specifies the alignment of the column text.
Column Width	Specifies the width of the column, in pixels. NOTE: If the text does not fit in the column, it is truncated in the measure instance. However, placing a pointer on the truncated text in DivePort opens a tooltip that displays the full text.
Advanced Properties
Style Column	Allows you to select a marker column that has style settings that you want to apply to the column in the portlet instance. Alternatively, you can define the following style properties: ValueFormat—Specifies the format of numeric values. For example, `ValueFormat="0.0000"`. See Formatting Numeric Values. You can use macros to specify custom formatting. For example, ValueFormat="$(ROW_DATA "down_color_arrow_rgb")". Font—Specify font properties. For example, `Font="Verdana 12pt bold"`. Color—Specify an RGB color code. For example, `Color="86,141,102"`. Indentation—Specify a number of pixels. For left- or center-justified items, space is added to the left of the item. For right-justified items, space is added to the right of the item. For example, `Indentation="15"`. Justification—Specify Left, Center, or Right. For example, `Justification="Left"`. You can specify multiple comma-separated styles. For example, `ValueFormat="0.000",Color="86,141,102",Indentation="15"`
Bottom Padding	Specifies the number of pixels between the rows.

Measure Factory License

Option

Description

Project

Specifies the Measure Factory project that provides the data for the portlet.

Opens the Select a Data Source dialog box, which you can use to select a different data source file.

Select Dimensions

Specifies the dimension that displays in the portlet left-most column. You can use the Search box to locate specific dimensions. Click the Menu icon to select an option for sorting the dimensions list.

Icon that looks like four squares arranged two by two.

Opens the Dimension settings page, which you can use to customize the dimension column, allow dimension changes, and select which columns are available for display.

Allow Dimension Changing

Enables the user to change the dimension that appears on the portlet. This option is cleared by default.

When enabled, this option enables a user to place the pointer on the dimension column heading to display a list of selectable dimensions as well as sort options.

Dimension Settings, Column settings for a specified dimension—Accessible by selecting a dimension and then clicking the Edit this column icon.

Title

Specifies the column label. The default Automatic, uses the dimension name as the column label.

Size

Specifies the column width, in pixels. The default Automatic, uses the length of the dimension name as a guideline. This option retains the set width if the dimension changes.

Font

Specifies the column font, size, and style used.

Indicator column settings—Accessible by selecting an indicator column, and then clicking the Edit this column icon.

Type

Specifies the indicator type. Click the Change the chart icon Icon that looks like four squares arranged two by two. if you want to select a different indicator type,

Title

Specifies the column heading. The default Automatic, uses the dimension name as the column label.

Size

Specifies the column width, in pixels. The default, Automatic, uses the length of the dimension name as a guideline. This option retains the set width if the dimension changes.

Value

Specifies the measure data to display.

Auxiliary Measure Value

Specifies a baseline or goal value that is defined in the measure factory.

Opens the time series mode settings box. Options are Basic and Advanced.

Basic time series settings

Basic features are as follows:

Date Range

Specifies the date range. Options are:

Year to Date (The first day of the year returns 0)
Year to Complete Month
Month to Date (The first day of the month returns 0)
Week to Date (The first day of the week returns 0)
Complete Year
Complete Month
Complete Week
Complete Day
Rolling Year by Month (the last 12 complete months)
Year
Future Months

Time period

Specifies the time period. Options are:

All
Current
Previous
Current Versus Previous
Current Versus Previous (%)
Previous Year
Current Versus Previous Year
Current Versus Previous Year (%)

Advanced time series settings

Advanced features allow the following customization of the time period:

To Date

Uses the specified time range and offset values to define the time series. The default is the current Year to complete Day. Other options are Year to complete Month,Year to complete Quarter, Week to complete Day, Month to complete Day, and Quarter to complete Day.

The offset value can adjust the time series by the specified time period. For example, setting the Time Range to Year to complete Day, with an offset of -1 Year, is the equivalent of last year to complete day. Available options for the offset time period are those time periods that are larger than or equal to the first time range.

Relative

Uses the specified complete time range and offset values to define the time series. The default is 1 Year, which is the current complete year. Other time period options are Day, Week, Month, and Quarter.

The offset value can adjust the time series by the specified time period. For example, setting the Time Range to 1 Year, with an offset of -1 Year, is the equivalent of the year before the current complete year. Available options for the offset time period are those time periods that are larger than or equal to the specified time range.

Absolute

Uses the specified time range and offset values to define the time series. The default is Month 1 of the current year. The other time period option is Quarter. This option supports custom calendars.

The offset value can adjust the time series by the specified number of years.

Thresholds

Click Add a Threshold to open the Threshold settings dialog box, which you can use to set a static threshold value or select a Measure Threshold value, Time Range and period, and indicator Color.

Click the gear icon to right of the Time Range to access the Advanced time series option.

	Opens the time series mode settings box. Options are Basic and Advanced. Advanced features allow further customization of the time period.
To Date	Available in advanced mode. Uses the specified time range and offset values to define the time series. The default is the current Year to complete Day. Other options are Year to complete Month,Year to complete Quarter, Week to complete Day, Month to complete Day, and Quarter to complete Day. The offset value can adjust the time series by the specified time period. For example, setting the Time Range to Year to complete Day, with an offset of -1 Year, is the equivalent of last year to complete day. Available options for the offset time period are those time periods that are larger than or equal to the first time range.
Relative	Available in advanced mode. Uses the specified complete time range and offset values to define the time series. The default is 1 Year, which is the current complete year. Other time period options are Day, Week, Month, and Quarter. The offset value can adjust the time series by the specified time period. For example, setting the Time Range to 1 Year, with an offset of -1 Year, is the equivalent of the year before the current complete year. Available options for the offset time period are those time periods that are larger than or equal to the specified time range.
Absolute	Available in advanced mode. Uses the specified time range and offset values to define the time series. The default is Month 1 of the current year. The other time period option is Quarter. This option supports custom calendars. The offset value can adjust the time series by the specified number of years.

More Settings

Available options depend on the indicator type.

For more information, see Indicator Portlet Options - Measure Factory License.

NOTE: Display settings are available for Indicator portlets only.

Miscellaneous Settings

Fixed Columns

Specifies the number of columns, starting from the left, that are fixed in place if a horizontal scroll bar is needed. If any columns are stacked, this setting indicates the number of stacks, not actual columns.

Default Item Height

Defines the minimum row height, in pixels. The default, auto, is defined as 20. If the tallest item is shorter than or equal to the Default Item Height, the defined value is used. If the tallest item is taller than the Default Item Height, the row height adjusts to display the entire item.

Show Totals

Specifies that the Totals row from the source data file displays on the portlet. This option is cleared by default.

NOTE: This option is unavailable when columns are stacked.

Show Titles

Specifies that the column headings shown in the Column, Type, Stack table on this dialog box appear as column headings on the measures portlet display. This option is selected by default.

Allow Sorting

Specifies that column sorting is enabled. The first time a measures portlet column is clicked, the data is sorted in one direction (ascending order for string columns; descending order for numeric columns). The next click to the same column reverses the sort. This option is selected by default.

Show Odd Row Coloring

Specifies that the row background color shifts for each row. Even rows default to the page background color (windowBackgroundColor) in the underlying skin.

You can edit the following skin properties to control the coloring:

Odd rows:
portletMeasuresOddRowColor
Even rows:
portletMeasuresEvenRowColor

Blank Window Text

Enables you to enter a statement in the text box that displays when the window underlying the portlet is blank. The statement displays instead of standard error messages.

Selecting the check box and leaving the text box blank makes the portlet invisible when the window is blank. You can use HTML and custom macros in this field.

Add a Column

Opens another Edit Measures Portlet dialog box, which you can use to add an indicator column to the measures portlet.

Display Settings

# Items

Specifies the number of items that display on the portlet. For example, setting this option to 5 produces a measure portlet with five rows showing the top five items based on the sort value. All items display by default.

Filter

Specifies a measure or Spectre calculation that is used to filter the data that displays. See also Using a Measure as a Filter.

Show Others

If # Items is selected, this option displays the sum of the remaining items. For example setting # Items to 5, and then selecting this option produces a portlet with the top five items plus a sixth row showing the sum of the remaining items.

Hide Null Values

If # Items is selected, this option does not display items with values that are null or unknown.

NOTE: This does not hide dimension values if there are any values that are not null or unknown in the row.

Sort By

Specifies the dimension or column on which to sort. The default is No sort.

Sort Up

Select if you want the dimension or value to sort up.

Sort Down

Select if you want the dimension or value to sort down.