“A picture is worth a thousand words”.
With this reference, WaveMaker gives you a tool to present your data in a pictorial form using the chart widgets. Using these widgets you can transform your data into either a line chart, column chart, pie chart, area chart, cumulative line chart, bar chart or a donut chart.
Following are the various charts offered by WaveMaker – Area, Bar, Bubble, Column, Cumulative Line, Donut, Line, and Pie.
The chart type property can be used to portray the data in various forms. Each type has its own advantages and disadvantages. Select the appropriate type depending upon the data and what you want to represent.
- Comparison of data is the most common usage of charts. It can be:
- Comparing quarterly sales figure over a period of 3 years in which case a column chart would be best
- Comparing the sales figures of say 10 different brands of any given product, wherein a bar chart would be most ideal
- Trying to follow a trend like population over a period of time would be best depicted by a line chart
- A composition of data like types of users for a product can be depicted accurately through a pie chart.
- Bubble chart can be used to show three dimensions in a chart. Apart from the x-axis and y-axis, the size of the bubble can represent the third dimension.
Choose the type according to your need, you might want to try different types before settling for the best.
Charts are used for graphical display of data and WaveMaker charts come with the following features:
- The Title, Sub Heading, and Icon can be set.
- Data can come from various sources like database, web service or another widget and can be accessed through binding to Live or Service Variables
- The layout can be set in terms of themes, positioning, formats for labels, captions, axis etc..
- Types of charts for various purposes.
- Data aggregation and grouping for displaying summary graphs.
- Run-time user-interaction
- Capturing user selection
Data can come from various sources as listed below:
- From Database,
- From Live Filter,
- From Web Services.
The X-Axis and Y-Axis values can be set to the fields from the data source, the chart is bound to.
Depending upon the data type of the underlying fields, you can choose the Data Display Format.
In the case, when the data source is from Web Services or Web Socket, you can choose the Format Type to be toDate or toNumber.
- the position of the Values – hidden, outside (default) or inside
- the Value to be displayed – as key, value, percent (default) or key-value pair
- The theme for charts can be chosen from a list of options.
- Custom Colors can be used to change the set of colors that comes predefined with the selected theme. The values for this property can be
- comma separated values, eg. red, green, blue
- bound to a static variable containing the color names or the color hash codes
- The position of the chart can be defined in terms of the offset values.
- Legend position can be set to be top or bottom.
- Layout of the values can be defined in terms of location, value format, caption for line charts and more
These options are available from the Advanced Settings of the chart. Apart from these properties, a Title, Sub Heading, and Icon can be assigned for the chart as a whole to be displayed on the top left corner of the Chart.
This property defines how the data is represented in the chart.
- Datapoint Interpolation Property determines how data points are joined and represented in the chart. This property is applicable to Line, Area and Cumulative Line Charts. Value can be set to:
- Cardinal for smooth curves, or
- Data Arrangement Property (available only for Column, Area and Bar Charts) controls whether to show the areas in:
- stream, or
Data Aggregation and Grouping
When dealing with charts bound to live variables, you can add additional functionality to these charts. You can order the data, group the data and show the aggregate functions in your chart. The aggregation functions available are average, count, minimum, maximum and sum.
- In the Aggregation property and Group by property can be used to set the aggregation functions.
- Order By property can be used to set the column by which the data needs to be sorted. By default, it will be set to the Group by column selected.
- The values to be depicted on x and y-axis are set to the group by and aggregation columns respectively.
- You can interact with the charts by selecting/unselecting the column names from the legend.
- Hovering mouse over any column displays the values of X and Y-Axis for that data point.
- These data points can be captured and used to bind to a widget for further display or computational purposes from the selected item of the chart widget
Capturing User Selection
You can capture user selection in two ways:
- The various outbound properties of a chart are available for binding to other widgets or variables. The fields under selecteditem will be from the underlying dataset used for binding
Here we have used the On select event of the chart: