GoogleBarChart Control
The GoogleBarChart control allows you to graph your data as a horizontal bar chart within your Newlook form.
Client support
Newlook Smartclient
Newlook Server
Use
A bar chart is useful when you have several categories of data that you would like to compare visually.
The GoogleBarChart control requires a 2-dimensional data source, where each row of data represents a horizontal bar in the chart. One column (specified in the DomainAxis property) will determine the label or category of each bar in the chart while a second column (specified in the DataAxis property) will determine the value of each category, in other words, the horizontal length of each bar.
There are two ways of specifying the data source for your chart:
1. Any datagrid control on your form can be used as the data source for you chart. The datagrid can be generated from a host subfile or bound to an external datasource.
2. If you have OpenLook installed on your IBMi, the SQL function can be used to query a host database file and return the results of that query as data source of your chart.
Regardless of which data source you use, the first column of data will be automatically assigned to the DomainAxis and the second column to the DataAxis. You can change these values however if you wish to chart different columns of data.
In the example below, the data source is an existing grid on our form. The first column of data, Language, has been set as the DomainAxis. It is represented as labels on each bar. The second column, Amount, has been set as the DataAxis. It determines the horizontal length of each bar.
Common GoogleBarChart Tasks
Use an existing datagrid as the source for your chart
- With the GoogleBarChart control selected, select the DataSource property and click the Field Picker (
) icon (your mouse pointer will change to a cross-hair pointer). - Click on the datagrid control that contains columns of data that you want to represent in the chart.
- In the DomainAxis property enter the name of the column that represents the category of data you are charting (i.e. the labels on each bar in your chart)
- In the DataAxis property enter the name of the column that represents the value of the data you are charting (i.e. the horizontal size of each bar)
Use the results of a query as the source for your chart
- With the GoogleBarChart control selected, select the DataSource property and enter the following expression:
=SQL("Connection", "SQL Query")
Where Connection is an existing connection to your host, and SQL Statement is a valid SQL statement.
- In the DomainAxis property enter the name of the column that represents the category of data you are charting (i.e. the labels on each bar in your chart)
- In the DataAxis property enter the name of the column that represents the value of the data you are charting (i.e. the horizontal size of each bar)
BE AWARE THAT:
OpenLook must be installed on your host machine in order to return the results of an SQL query on a host database file.
Properties
Newlook Smartclient | Newlook Server | 
Deprecated
| 
Obsolete
|
Property |
Client |
Description |
|
|
Gets or sets the control's animation style. |
|
|
|
Gets or sets the duration of chart animation, in milliseconds. |
|
|
|
The green screen column coordinate that marks the beginning of the object. Read only. Host generated controls only. |
|
|
|
Gets or sets the data set that will become the label for the chart segment or bar. |
|
|
|
Gets or sets the name of the data source for the control. |
|
|
|
Gets or sets the data set that will determine the chart segment or bar. |
|
|
|
Gets or sets the enabled state of the object. - limited, Newlook Smartclient-only support. |
|
|
|
Returns or sets the height of the object's size in pixels at default size, which is the object's size at design-time. |
|
|
|
Determines the distance, in pixels, between the left edge of the control and the left edge of its form or parent container at default size, which is the object's size at design-time. |
|
|
|
Gets or sets whether the chart will render according to Google's Material Design standards. |
|
|
|
Gets or sets the name of this object. |
|
|
|
The green screen row coordinate that marks the beginning of the object. Read only. Host generated controls only. |
|
|
|
Gets or sets a value which determines the control's tab order. |
|
|
|
Gets or sets whether the Tab key can be used to set focus to the control. |
|
|
|
Gets or sets user defined information for the control. |
|
|
|
Gets or sets the chart's title. |
|
|
|
Determines the distance, in pixels, between the top edge of the control and the top edge of its form or parent container at default size, which is the object's size at design-time. |
|
|
|
Returns a value which specifies the control's type. Read only. |
|
|
|
Gets or sets whether the control, object or form is visible or hidden. |
|
|
|
Gets or sets the width of the object in pixels at default size, which is the object's size at design-time. |
See Also
© 2004-2021 looksoftware. All rights reserved.