Creating an Active Technologies Chart

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.

Procedure: How to Create an Active Technologies Chart

With in Chart mode, you can perform this procedure in Query Design view or Live Preview.

  1. On the status bar, in the Output Types menu, click active report or active PDF.
  2. On the Format tab, in the Chart Types group, click the button of the chart that you want to create. Bar chart is the default.

    The chart appears on the canvas.

  3. Populate the chart with your data in one of the following ways:
    • Drag the dimension fields and measure fields onto the chart.
    • Drag the dimension fields and measure fields into the appropriate field containers in the Query pane.

    The following image shows an HTML5 pie chart that displays the sum of the values in the Quantity Sold field by Product Category.

    HTML5 Pie Chart

Active Technologies Options for Charts

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.

Usage Notes for Active Technologies Charts

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:

  • Tag Cloud
  • Funnel
  • Pyramid
  • Waterfall
  • Histogram
  • Radar Line
  • Radar Area
  • 3D Area

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:

  • When the original chart is a non-bucket chart
  • When the chart is created from a tabular report

WebFOCUS

Feedback