Topics: |
How to: |
An active chart is a chart that is designed for offline analysis. For more information, see Active Technologies Report Overview.
Note: Active Technologies supports the use of HTML5 extensions, which are user-supplied, custom chart types that access resources external to Web Query.WebFOCUS. For details on the structure of an extension and the steps for creating your own, as well as the process for adding it to the chart library, see the Adding Your Own Chart Types to the Chart Library chapter in the Creating HTML5 Charts With WebFOCUS Language manual.
With in Chart mode, you can perform this procedure in Query Design view or Live Preview.
The chart appears on the canvas.
The following image shows an HTML5 pie chart that displays the sum of the values in the Quantity Sold field by Product Category.
Options for an active chart are described in the following table.
Note: For charts that employ the new attribute syntax, only the following four icons display: More Options, Advanced Chart, Original Chart, and Aggregation. If you have applied a filter, the Remove Filter icon displays.
Option |
Definition |
---|---|
More Options ![]() |
New. Creates a new instance of the chart. This option is available only when the chart is created from a column menu on a tabular report. |
Group By (X). Changes groups by the horizontal sort field. |
|
Add (Y). Adds a vertical sort field. |
|
X-Axis. Specifies a measure or dimension sort field. Applies to scatter charts. |
|
Y-Axis. Specifies a measure. Applies to scatter charts. |
|
Arrange By. Specifies the marker color. The marker color depends on the field assigned to the color attribute. If no field is assigned to this category, then all of the markers will be the same color. Applies to scatter charts. |
|
Export to. Exports to Excel, Word, or PowerPoint. |
|
Stacked. Stacks the risers on top of each other, with the length of each riser representing the data value. Applies to column charts. |
|
Top. Displays the top values. Options are Top 3, Top 5, Top 10, and Clear Top. Applies to pie charts. |
|
Trend. Draws a trendline and equation label for an individual series. Applies to scatter charts. |
|
Chart/Rollup Tool. Opens the Chart/Rollup Tool, which you can use to select multiple group fields in the chart or rollup table generated. The Chart/Rollup Tool contains a list of columns available in the active report and Group By and Measure sort fields. Drag the columns into the desired sort field. Note: When working with the Chart/Rollup Tool for active charts (specifically those with the new chart attribute syntax), the Series tab is not supported. It is available with charts that are created with tabular reports or stand-alone charts that do not use the new chart attribute syntax. |
|
Restore Original. Restores the active report to the default state specified in the report procedure. |
|
Column ![]() |
Displays data as a column chart. |
Pie ![]() |
Displays data as a pie chart. |
Line ![]() |
Displays data as a line chart. |
Scatter ![]() |
Displays data as a scatter chart. |
Rollup ![]() |
Displays the chart as a rollup table. |
Advanced Chart ![]() |
Opens the Chart/Rollup Tool. |
Original Chart ![]() |
Restores the active chart to the chart type specified in the report procedure. |
Lock/Unlock ![]() |
Freezes the chart or rollup table. You can link or unlink a chart or rollup table to the filters that you have applied in your report using the Freeze Chart or Freeze Rollup icon. The icon indicates whether the report is linked to the filter (Freeze Chart or Freeze Rollup) or not (Unfreeze Chart or Unfreeze Rollup). This option is available only when the chart is created from a column menu on a tabular report. |
Aggregation ![]() |
Applies the following options to a Measure field: Sum, Avg, Min, Max, Count, and Distinct. The default value is Sum. |
Remove Filter ![]() |
Removes a filter from a chart. You can apply a filter by pointing to or lassoing an area of the chart and then clicking the Filter Chart or Exclude from Chart option from the chart tooltip. |
If you are working with an AHTML chart that does not have the new chart properties (specifically, non-bucket AHTML charts), you will encounter problems if you change the chart type to one of the following chart types using the Advanced Chart tool at run time:
By default, these chart types are hidden in the Advanced Chart tool when the original chart is an AHTML bucket chart. These chart types are available under the following circumstances:
WebFOCUS | |
Feedback |