Wyn Enterprise User Guide

Wyn Enterprise: Combined Chart

A Combined Chart (also known as a composite chart) is a combination of two different types of charts in a single plot area, for instance, a bar and a line chart laid in a single plot. Combined charts are best used to compare different data sets that are related to each other such as actual and target values, total revenue and profit, temperature and precipitation, etc. Note that these charts may require multiple axes to cater different scales for different values.

Combined Chart Example

In Wyn Enterprise, column chart and line chart are the default combination for the combined chart. This chart consists of columns on the primary axis and a line on the secondary axis. This chart is most suited where ranges are vastly different. Combined charts can be a combination of any of the following charts - line chart, column chart, area chart, and stacked column chart.

Design a Combined Chart in Wyn Enterprise

From the Dashboard Toolbox, open the Data Visualization node and drag-drop the Combined Chart scenario onto the design area.

Adding a chart scenario from the Dashboard Toolbox

Bind Dataset to Chart Scenario

With the scenario selected, from the Data Binding tab, select the dataset. Once the dataset is successfully loaded in the designer, the data binding panel automatically expands and displays the data attributes available in the dataset.

The following image shows the chart scenario bound to the 'RetailDataset' dataset.

Adding a dataset to chart scenario

On dragging and dropping the data attributes to the data binding area of the scenario, the chart is plotted accordingly, with a default chart title on the design area.

Chart Scenario with bound attributes

Format Data Attributes

To format the data attributes and control the display of data, you can perform a variety of operations such as renaming, modifying data format and display unit, creating a hierarchy field, applying an aggregation method, etc.

For more information about these operations, see Data Attributes.

In the following chart scenario, the data format for the data attribute is modified to display the sales revenue in 'currency'.

Formatting fields in a chart

Analyze Data

Wyn Dashboards scenarios support rich data analysis and exploration capabilities that can help analyze massive amounts of information and make data-driven decisions. For example, adding filters to the scenarios, sorting data, adding reference lines, trend lines, etc. Note that you can apply all these operations using the Action Bar corresponding to each scenario in the designer.

For more information, see Data Analysis and Interactivity in Dashboards.

In the following chart scenario, the filter is applied to show data only for the selected retailer countries, that is, the United States, Canada, Japan, and China.

Trendline in a chart scenario

Customize Appearance

You can customize the default chart appearance by setting properties in the Inspector tab of the scenario such as adding a border, modifying data labels, setting chart style, renaming chart title, setting corner radius, etc.

  1. Show Grid Lines
    To display horizontal grid lines in a chart scenario, you can set the Show Grid Lines property of the Left or Right Value Axis to 'True'. By default, this property is set to 'False'. You can also specify the grid line color by choosing a suitable color from the color palette.

    Showing gridlines in a chart scenario

  2. Format Axis Titles
    You can show or hide axis titles for a chart by using the Show Title property for the Legend, Value axis, and Category axis. When you set the Show Title property to True, the axis titles are enabled. Wyn Dashboards set data attributes' names as the axis titles. You can provide a custom name to the axis title by renaming the attributes in the data binding area. For more information on renaming data attributes, see the topic on Rename an Attribute.

    Changing axes titles in a chart scenario

  3. Change Axis Scale
    To customize the scale values for the Value axis (Left or Right) of a chart scenario, use the Max Value, Min Value, or Interval properties and set them to some suitable values.

    Changing axes titles in a chart scenario

  4. Change Line Style
    By default, Wyn Dashboards use straight lines to connect the data points in the chart. To change the default line style in the chart, use the Line Style property and set it to 'Spline' or 'Step'.

    Changing line style in a chart scenario

  5. Show Dots
    To emphasize the data points along the line, use the Show Dots property in the Inspector tab and set the property to 'True'.

    Displaying dots in a chart scenario

  6. Change Chart Type
    You can change the default combination for a combined chart in the Data Binding area of the selected scenario. Click the Settings icon Settings Icon next to the Value axis for which you want to change the chart type.

    Changing chart type in a combined chart scenario

  7. Show Data Labels
    To improve your chart’s readability, you can set the visibility of data labels for value axes through the Show Data Label property of the Left Value Data Labels and Right Value Data Labels. For example, in the below chart, the exact revenue values for the left axis is difficult to understand without the data labels because they add more details to the chart. Also, the placement of the data labels in the chart can be controlled using the Location property. You can set the property to 'Around' or 'On Slice' to display the labels around the data points or place them on the slices.

    Set show data labels