Wyn Enterprise User Guide
- An Introduction to Wyn Enterprise
- Document Portal for End Users
- Using Report Designer
- Create Static Report
- Create Tabular Report
- Create Parameterized Report
- Create Master-Detail Report
- Create Pivot Report
- Create Report with Chart
- Styles and Themes
- Expression Editor
- Report Templates
- Working with Dashboards
- Dashboard Designer
- Selecting a Dataset
- Data Attributes
- Dashboard Scenarios
- Charts and KPIs
- Calc Charts
- Containers and Components
- Dashboard Appearance
- Preview Dashboard
- Export Dashboard
- Data Analysis and Interactivity
- View and Manage Dashboards
- Governing Data and Resources
- Create Data Source
- Data Source Connections
- Create Dataset
- Create Semantic Model
- Secure Data Management
- Create Floor Plan
- Upload Resources
- Using Dashboard Designer
- Section 508 Compliance
Wyn Enterprise: Column Chart
Column charts are used to compare categorical data through vertical bars with categories plotted on x-axis and data values along the vertical axis. Column charts find applications where the number of values is too large to be used on an x-axis. For example, the population share of different countries across the globe can be represented using a column chart.
Wyn Enterprise supports the following types of column charts.
Column Chart : It is used to compare categorical data through the vertical bars, where length of each bar represents the value of the corresponding category.
Range Column Chart : It is similar to a column chart where each bar represents the difference between the minimum and maximum values for each category.
Stacked Column Chart : It is used to display the relationship of specific items to the whole across different categories and plot values in two-dimensional vertical rectangles. This chart stacks the data series vertically (in a vertical direction).
Percent Stacked Column Chart : It is used to perform comparisons of percentages that each of the values are contributing to the total, across all your categories in the spreadsheet. This chart stacks the data series vertically and also equalizes the plotted values to meet 100%. The plotted values are displayed in two-dimensional rectangles.
Design a Column Chart in Wyn Enterprise
From the Dashboard Toolbox, open the Data Visualization node and drag-drop the Column Chart scenario onto the design area.
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 'TechnologyDataset' dataset.
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.
Format Data Attributes
You can format the data attributes in a dataset by performing a variety of operations such as renaming, modifying data format and display unit, creating a hierarchy field, applying an aggregation method, etc. Using these operations, you can control the display of data attributes in a scenario.
For more information about these operations, see Data Attributes.
The following image shows the Display Unit property for the value axis and data labels in a chart set to 'Thousands'.
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 scenarios, sorting data, 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.
The following image shows relevant data by applying filtering on data in the chart scenario for the following months i.e. Jan, Feb, Mar, and Apr.
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.
Show Grid Lines
To display horizontal grid lines in a chart scenario, you can set the Show Grid Lines property of the 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.
Format Axis Titles
You can show or hide axis titles for a chart by using the Show Title property for the Value and Category axes. When you set 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.
Change Axis Scale
To customize the scale values for the Value axis of a chart scenario, select the axis and set the Max Value, Min Value, or Interval properties.
Analyze Multivariate Data
In complex Chart scenarios, you may want to analyze multivariate data. With Wyn Dashboards, you can easily establish potential relationships and correlations between multiple data attributes for such analysis.
For example, if you want to analyze the number of tickets by ticket types and priorities, you need to bind the Axis (Category) to multiple dimensions, that is, TicketType and Priority in the data binding area as shown.
Set Corner Radius
Round corners make the charts look more modern and appealing. You just need to specify the value of the radius in Corner Radius property for the rounded corners. This property lets you change the default square-shaped corners in a chart to rounded corners as shown.