Configuring Lists, Charts, and Filters › How to Configure a List › Display an Aggregation Field as a Bar or Column Graph

Previous Topic: Add an Aggregation Row for a Number Field to a List Portlet

Next Topic: How to Configure a Chart

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.