Scatter Chart
The scatter chart is used to observe the relationship between data points.
The following is a list of the fields in the View Properties box in the dashboard designer for scatter chart. There are some required fields to be set for each created view.
Basic Properties
The View Properties fields vary in different charts. Below are the basic properties in the View Properties box.
| Field | Description | Mandatory |
|---|---|---|
| View Type | Type of chart, table or view. | Yes |
| Title | Name of the view. | No |
| Dataset | Data used for the chart, table or view. | Yes |
| Subset | Partial data from a dataset used for the chart, table or view. | No |
| Group | Places the output of the dataset/subset into separate groups or data traces based on field selected. | Yes |
| X | X values be set on the X axis. | Yes |
| X Aggregation | Determines the operation to be applied on the values in the “X” field. Depending on the field type of “X”, the options available may vary. Possible options are count, average, and/or summation. |
Yes |
| Sort X | Sorts the X-Axis. | Yes |
| Y | Y values be set on the Y axis. | Yes |
| Y Aggregation | Determines the operation to be applied on the values in the “Y” field. Depending on the field type of “Y”, the options available may vary. Possible options are count, average, and/or summation. |
Yes |
The dataset and subset data derive from Dataset Management. Choose the right chart from the View Type and data points to build a view. Also, be consistent in using the color scheme and formatting.
Other Properties
The other property fields are available to enhance the view. Below are the other properties in the View Properties box for the scatter chart.
| Field | Description | Default |
|---|---|---|
| Controlled By | Links dashboard controls to the view. One or more controls can be added to affect the data displayed on the view. |
Empty |
| Colour Scheme | Determines the color palette used for the view. | Default |
| Sort Group Pattern | Defines the field to sort the “Group” field. | Empty |
| Extra Lines | Sets additional lines over specific views. This is especially useful for setting indicators or threshold values on views. One or more can be added. |
Empty |
| Drill | Allows drilling down data on the selected group level. | Empty |
| Mode | Sets the display mode of the scatter chart. For example, you can show the markers with or without text. |
Markers |
| Text Position | Determines the position of the text to be shown in the view (if text is selected in the “Mode” property). | Auto |
| Text Format | Sets the format of the displayed data point values. | Empty |
| Legend | Chooses the chart legend visibility in the Legend properties as well as how you want to display the legend. The legend orientation displays either in vertical or horizontal order. | Selected |
| Hover Template | Customise the content shown when hovering over the view. | Empty |
| Click to Page | Adds a link to another view. | Empty |
| Click to Page Tip | Adds a brief description of the link above. | Empty |
| Maximisable | If selected, places a maximise button on the top right of the view (when not in edit mode). This will maximise the view to fill the browser. |
Not selected |
| Margins | Allows adjusting margins and padding between charts and grid. | Default settings |
| X-Axis, Y-Axis | Controls the axis’ title, visibility, formatting, show grid or line. | Default settings |
| Advanced | Add a special CSS class, data script and/or layout overview to the view. | Empty |
| Config Options | Config Options consists of the following: - Scroll Zoom - allows the mouse wheel to zoom in/out of the chart - Display Modebar - controls whether the bar of icons at the top right of the chart should appear always, never or only when hovering over the chart - Hide Modebar buttons - chooses which buttons (icons) to include in the Modebar |
Default settings |
Example: Using Extra Line
The scatter chart is used to observe the relationship between data points. This may not show enough information. You can use the “Extra Lines” property to provide one or more extra indicators or threshold values to the view. In the example below, 2 extra lines are added to show the summation for total cost and total profit.
In the “Extra Lines” property, click on the “+” icon below it. Click on the white colour bar to display the colour palette and select the desired colour. Click on the “…” icon to display the “Extra Line Properties” dialog box. Enter the appropriate name for the line, which will be shown in the legend at the upper right corner. Select the appropriate values from the drop-down lists and checkboxes.
Click on the “OK” button to save the changes and close the dialog box. Two extra lines are now added onto the view, which shows the total cost and total profit summations. These 2 lines provide more information on the scatter chart.
You can also add an extra line to indicate a certain threshold or value. In the “Extra Line Properties” dialog box, provide an appropriate name for the line in the “Name” field. Select the “Fixed” field and enter the threshold desired in the “Fixed Value” field. Click on the “OK” button to save the change.
The red fixed line is added to the view to indicate a threshold of 200M.
