Previous TopicNext Topic


How to group category series data

  1. On Chart, choose Format Chart--Series--Category Series.
  2. Chart--Format Chart--Series--Category Series appears.
  3. In Grouping, select Enabled.
  4. In Type, to specify the type of data that the category series contains, select one of the following options:
    • Text
    • Numeric
    • Date and Time
    The value you select determines how the chart builder formats the category series values.
  5. If you group Date and Time data, you can specify the units to use to format the category series value, such as Seconds or Minutes. To specify the units to use, in Unit, select a value.
  6. In Interval, select a number that represents the size of the groups to create. For example, to group three-row sequences of text data, select 3. To group numeric data in sections of four, select 4.
  7. In Aggregate Expression, select the function to use to aggregate the data in the group:
    • To display the average of the values that belong to each group, select Average.
    • To display the total of the values that belong to each group, select Sum.
    Choose Finish.

(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic