Chart page

On the Chart page you can:
•    Change the page title.
•    Customize the styling, if required.
•    Add a Help text. •    Enable the Print all option, to display a print button on Publisher charts.

Search block

Specify the fields for which results are returned to the user when clicking Search in the Search page.

If you click Yes in the Search immediately field, the search results will immediately be available to the user when displaying the form (in this case, the search will be non-specific).

For usability, it is recommended to turn Search immediately on. However, this may impact the performance of the system.

Fixed filter

Specify a filter for your chart definition. The filter will allow you to fine tune your result data. The chart query will take into account the selection you make here.

Sub list reference

To enable users to click in the chart area to zoom into chart details, you can add a Publisher sub-list.

You can configure this web definition as required. For more information, see Adding a Publisher list.

Sub chart reference

To enable users to click in the chart area to zoom into chart details, you can add a Publisher sub-chart.

You can configure this web definition as required. For more information, see Adding a chart.

Click action operation

Here, you specify how the details of a sub-list or sub-chart are displayed:
•   Show in current frame: to show details in the current gadget.
•   Show in top frame: to display sub-chart/list in the top frame of your browser.
•   Show in parent frame: to replace sub-chart/list in the current web page.
•   Show in new browser window: to display sub-chart/list in a new browser tab.
•   Send javascript event: A postMessage containing a URL is sent to the parent frame. The URL can be used to create a customized representation.

Log query as event log

Click Yes if you want to log the query into the event log. The event log is available in Supporting data > Log Viewer. This may be helpful in analyzing query performance.

Charts are based on queries that are executed on the database. Depending on your database, you need to construct these queries on either the MSSQL query tab or on the Oracle query tab.

Make sure to leave the (([&SEARCHFIELDS]) and ([&FILTERFIELDS])) on the tab.

To include special, non-latin based unicode characters in chart queries, prefix the SQL code with 'N', for example: N'失敗/クローズ'. Without this prefix, the SQL server will interpret the special characters incorrectly and will display the special character part as '?????'.

For samples of charts and SQL, see Chart examples.

Chart type

Select the type of chart you want to create. The following chart types are available:
•    Angular gauge
•    Area
•    Candle stick
•    Bar
•    Doughnut
•    DualY
•    Line
•    Pie
•    Radar
•    Zoom line
•    For more information on these chart types, see Supported chart types.

Chart sizing

Indicate whether your chart dimensions should be adjusted relative to the website in which it is displayed.

If you select Relative, the chart dimensions will scale relative to the website dimensions.

If you select Fixed, the chart dimensions will remain as is when changing the website dimensions.

Height

Specify the chart height. If you selected a fixed chart size, your value here should be in pixels. If you selected a relative chart size, your value should be a percentage (number only).

Width

Specify the chart width. If you selected a fixed chart size, your value here should be in pixels. If you selected a relative chart size, your value should be a percentage (number only).

Title

Specify a title for the chart.

Subtitle

Specify a subtitle.

X-axis label

Specify a name for the X-axis.

Y-axis label

Specify a name for the Y-axis.

Number prefix

Specify a prefix to be used preceding all numbers visible on a graph.
Example: $

Number suffix

Specify a suffix to be used for all numbers visible on the graph.
Example: p.a (per annum, or yearly).

Show bar horizontally

Click Yes if you want to display the bars of a bar chart horizontally.

Show in 3D

Click Yes, if you want to display your chart in 3D. The chart will be displayed tilted, giving it a three dimensional appearance.

Show stacked

Click Yes, if you want to display the bars of your chart stacked on top of each other.

Show single Y-axis

Click Yes, if you want to display a single Y-axis for your chart.

Click No, if you want to display a double y-axis for your chart.

Fullscreen

Click Yes, if you want to display your chart fullscreen.

Show title when fullscreen

Click Yes, if you want to display a title when displaying your chart fullscreen.

Custom settings

Specify any specific chart settings, for example: chart border, background, gradient fill, background image.

For examples and more settings, see > Configuring Charts or Custom Settings.

Angular gauge dial settings

Specify any specific dial settings, for example: border and background, radius and rear extension, base width and top width, hover effect and more.

For examples and more settings, see https://www.fusioncharts.com/dev/ > Configuring Charts or .

Secondary Y-axis 1-5

Specify the secondary Y-axis labels that will be used with DualY charts. The labels and their corresponding value need to be referenced in your SQL query.
select
Year as XAxis
, bstack as XAxisSub
, bstack as XAxisCode
, bar as YAxis
, 100 as YAxis1Sec
, 150 as YAxis2Sec
, 200 as YAxis3Sec
, 250 as YAxis4Sec
, 300 as YAxis5Sec

For angular gauges you should define two sets of ranges: unfiltered and filtered. The unfiltered ranges are used to display the query without taking into account the Search fields. This will likely result in a larger data set. The filtered ranges will take into account the Search fields, and as the expected result will be less than that of the unfiltered result, the range size will be less.

The Search fields are optional. If no Search fields are defined, only the unfiltered configuration will be applied.

Start range unfiltered

Specify the starting position of the angular gauge dial. Typically it starts at 0.

Low range unfiltered

Enter the value for the low range. Angular gauges have three ranges: low, middle and high. Each range is marked by a specific color.

Middle range unfiltered

Enter the value for the middle range.

High range unfiltered

Enter the value for the high range.

Start range filtered

Specify the starting position of the gauge dial. Typically it starts at 0.

Low range filtered

Enter the value for the low range. Angular gauges have three ranges: low, middle and high. Each range is marked by a specific color.

Middle range filtered

Enter the value for the middle range.

High range filtered

Enter the value for the high range.

Render Y-axis as

Specify how to render the Y-axis. The available options are:
•    Line
•    Area
•    Column

Here you can specify chart-specific colors. If these are not specified, the default site colors are used.

Here you can provide a customized translation if required.

In CSS classes you can specify your customized CSS class. If this field remains empty, the default CSS styling is applied. If this field contains a reference to a CSS class that is specified on the site, this styling will be applied.

For more information, see Customizing CSS styling.

Here you can provide a script for enabling dynamic forms.