How to:
Reference: |
Advanced Merge functionality is enabled by default in Advanced Graph Assistant and enables you to build complex graph requests with multiple sort fields. Graphs are merged according to the dimensions specified by adding sort fields to the X group axis, Series-legend, and Multi-graph sort containers ("buckets"), located below the Chart icon in the query pane. These buckets determine how and where multiple sort fields are plotted, and are represented by the X group axis, Series-legend, and Multi-graph icons, as shown in the following image.
You can add sort fields to these buckets to create multiple graphs, nested X-axis graphs, merged graphs, and any combination of these graph types.
Each sort field bucket has characteristics and limitations, as described in the following:
Creates a nested X-axis if more than one sort field is added to this X group axis dimension. The sort field or fields added to the X group axis bucket determine how the X-axis labels appear.
The number of X group axis sort fields must be 1, 2, or 3, and can never be 0.
Creates secondary X-axis fields and merges the values into one graph. The sort field added to this Series-legend bucket determines how the legend data labels appear.
The number of Series-legend sort fields must be 0 or 1.
Creates outermost sort fields and serves as a page break for bursting into multiple graphs. The sort field added to this Multi-graph bucket is not plotted on the graph, but each unique sort field value is displayed for every bursted graph. The number of graphs created depends on the number of values for the sort field you select. For example, if you select a sort field with two values, two graphs are generated, and if you select a sort field with ten values, ten graphs are generated.
The number of Multi-graph sort fields must be 0 or 1.
Note: Advanced Merge also enables you to create Coordinated Reports in Power Painter where multiple TABLE and GRAPH requests are tied together by common sort field values. For more information about Power Painter, see the Creating Compound Reports With Power Painter manual.
WebFOCUS |