Configuring a Chart widget

A chart widget displays a graphical chart built from the data retrieved from the Alloy Navigatordatabase. Two types of chart sources are available:

  • View-based chart with drill-down support - a chart based on a shared view, which can be additionally filtered as needed. The drill-down support allows technicians to click a chart element to open the data view associated with the clicked element.

  • Static chart based on custom SQL - a static chart based on a custom SQL query. This type gives you maximum flexibility; however, static charts do not have drill-down support.

You specify properties of a new Chart widget or modify properties of an existing widget of this type using the Chart Widget Properties window.

NOTE: For details on initial steps of widget creation or modification, see Creating widgets or Modifying widgets.

Chart Widget Properties window

The Widget tab of this window contains the following fields and controls:

General section - specifies general widget properties:

  • Name - the "internal" name of the widget, which identifies it in widget lists.

  • Title - the widget title, which will be actually displayed in dashboards.

  • Allow to minimize widget - specifies whether users can minimize this widget on dashboards.

Chart data section - specifies the source data for the chart:

  • Source - the type of chart source. The selected value defines the other options available in this section.
    • View-based chart with drill-down support - builds a chart with drill-down support that uses an existing shared view as the data source.

      • View Name - the shared view serving as the chart source. To specify a view, click Select and double-click the shared view.

        IMPORTANT: The selected shared view must be assigned to the same security roles the dashboard is assigned to. Otherwise, the technicians who do not have permissions to access the shared view will only view the chart but will not be able to drill down, i.e. to click a chart element and open the data view. For details, see Assigning dashboards to security roles and Assigning shared views to security roles.

      • Group by - the field for grouping data records. Values of the chosen field are horizontal X axis labels.

        TIP: Click Preview to preview the chart itself and view the chart source table.

      • Then by - the field for second-level grouping (optional). When specified, the chart displays multiple data series, grouped by two levels. The values of the Group by field provide series names (shown in the legend), the values of the Then by field are horizontal X axis labels.

        TIP: Click Preview to preview the chart itself and view the chart source table.

      • Function - the aggregation function for generating Y chart values for each X value.

      • Order by - the field for sorting chart elements on the X axis and the sorting order (either Ascending or Descending).

      • Filters button - allows you to add a filter for the chart data or modify existing chart filters. For details, see Manage Chart Filters window.

    • Static chart based on custom SQL - creates a static chart that uses a custom SQL query as the chart source.
      • Enter the SQL query... - the SQL query. Two types of SQL queries are supported:

        • A SQL query that returns two columns. In this case, the chart shows a single data series. The first column contains horizontal X axis labels and the second column contains data series. For example:
          select Priority, count(*) from Incident_List group by Priority
        • A SQL query that returns three columns. In this case, the chart displays multiple data series. The first column provides series names (shown in the legend), the second column contains horizontal X axis labels, and the third one contains data series. For example:
          select Priority, Assignee, count(*) from Incident_List group by Priority, Assignee

        TIP: Click Preview to preview the chart itself as well as the chart source table.

Display properties section - specifies the graphic properties of the chart and allows you to preview the result:

  • Chart Type - the type of chart to be built: Bar, Line, or Pie.

  • Palette - specifies the color palette for the chart. If necessary, you can customize colors for particular chart elements by clicking Adjust Colors. For details, see Assign Colors window.

  • Chart Height - the chart height in pixels.

  • 3D Effect - specifies whether the chart appears in 3D. When the check box is cleared, the chart appears in 2D.

  • Gradient - specifies whether a gradient will be applied.

  • Show legend - specifies whether the chart displays the legend and the legend position.

  • Show marks - specifies whether the chart displays marks (small boxes with values next to chart elements) and the the style of marks.

    ClosedClick here to view the supported styles with descriptions.

    Style Description Example

    Value

    Vertical Y axis values.

    Percent

    Percentages, when the sum of all Y axis values considered 100%.

    When the chart shows multiple data series, the percentage is calculated for each series individually, where 100% is the sum of all chart values within a series.

    Label

    Horizontal X axis labels.

    Label and Percent

    Horizontal X axis labels and percentages.

    When the chart shows multiple data series, the percentage is calculated for each series individually, where 100% is the sum of all chart values within a series.

    Label and Value

    Horizontal X axis labels and vertical Y axis values.

    Legend

    Legend text.

    Percent Total

    Percentages and the total Y axis value (the sum of all Y axis values).

    When the chart shows multiple data series, the percentage is calculated for each series individually, where 100% is the sum of all chart values within a series.

    Label and Percent Total

    Horizontal X axis labels, percentages and the total number.

    When the chart shows multiple data series, the percentage is calculated for each series individually, where 100% is the sum of all chart values within a series.

    X value

    Horizontal X axis sequence numbers, starting with 0 (the same as "Point Index").

    X and Y values

    Horizontal X axis values (the same as Point Index) and vertical Y axis values.

    Series Title

    Series names, when the chart shows multiple data series.

    When the chart shows a single data series, the marks display Series [SeqNo] values.

    Point Index

    Horizontal X axis sequence numbers, starting with 0 (the same as "X Value").

    When the chart shows multiple data series, the sequence number is calculated for each series individually.

    Percent Relative

    Relative percentages, when the vertical Y axis value of the first chart element considered 100%.

    When the chart shows multiple data series, the percentage is calculated for each series individually, where the value of the first element in a series considered 100%.

  • Show X axis labels - specifies whether the chart displays X axis labels. The option in only available for the Bar and Line chart types, since the Pie chart type does not have the X axis. You may want to clear the check box if X axis labels overlap, which makes the chart look untidy.

    NOTE: In some cases, X axis labels may not be shown in the chart despite the fact that this option is selected. For example, this may happen when you select the Show Legend check box. The reason is that X axis labels and the legend would duplicate each other.

  • Preview button - opens the Chart Preview window, where you can view the chart built according to the specified settings and the data it is built on. The Chart Preview window also allows you to customize chart colors.

Advanced properties section - specifies the following advanced properties of the chart:

  • Limit the length of the legend text to - limits the length of legend text and specifies the maximum length in characters. Shortened text will appear with an ellipsis at the end.

    NOTE: When the type of the chart is Bar or Line and the chart shows a single data series, this option limits the length of captions for chart elements.

  • Limit the number of elements to display to - limits the number of chart elements to display and specifies the limit. When the number of elements exceeds the limit (N), the chart displays only the first N of them. The order of data retrieval is specified in the chart source definition within the Chart Data section.

  • Adjust Colors button - reveals the Assign Colors window where you can customize colors of the chart elements.

The Dashboards tab of the Chart Widget Properties window shows the list of dashboards where the widget is used. For details, see Viewing dashboards where a widget is used.