Adding Data to a Chart
Before you can start creating a chart you must select a data source that contains the data you want to use. You must then define the data that will be displayed in the chart.
Note: If you are unsure what chart type is best for displaying your data, see the section above.
Follow the instructions below to add data to your chart:
1. In the Dashboard, choose a dashboard panel and click 
(Insert content) and select Chart. The
Select Data Source dialog appears.
2. Select the data source from the list of available choices. The data source contains the content you want to display in your chart. The Query Editor appears.
3. The Query Editor allows you to retrieve dynamic data from a database for display in a chart. Defining your query is the first step in ensuring that the correct data is selected. In the Query Editor, click (+) next to a category name to display its associated table columns.
4. Click the small green arrow to place the column name under Selected Columns. In the example below, the Entry Point Name column has been selected and moved under Selected Columns. Notice that the column names appear under Selected Columns. Continue adding columns as needed.
5. Now add the Conditions; these are your constraints that filter what you are selecting. You can add multiple conditions. In the example below, the search is limited to time.
Under Combine, you can select your constraint (and, or, and not, or not) from the drop-down list. Under Comparisons you can click the drop-down list to display options for comparisons, =, <, >, and so on. You can also select an aggregation type from the drop-down list for table columns that contain numeric data. The table below contains a definition for each aggregate type:
Aggregate Type | Description |
SUM | Sums a column's values |
COUNT | Counts a column's values |
AVG | Averages a column's values |
MIN | Selects the minimum column value |
MAX | Selects the maximum column value |
Note: Click Preview at any time to view the data associated with your query.
6. Add the columns that you want to Order By. The ordering of the selected data is accomplished by one or more columns in a table. For example, you can sort the data by Customer name and address.
7. Click OK in the Query Editor when you are done. The Chart Designer window appears.
8. Under Data, click the drop-down arrows to display and select the table columns:
Data Definition | Description |
Series Column | Series show up as the individual columns on a bar chart and as individual lines in a line chart. Area charts display each series as a point. |
Category Column | Categories are displayed as bars or groups of bars on the x-axis (horizontal axis). In line charts, categories are usually associated with time periods. In area charts, the x-axis displays the category labels. Note: If you do not want to display categories, select None. |
Values Column | The value is always numeric. The value determines the height of columns in a bar chart and the height of lines in a line chart. In area charts, the y-axis values determine the heights of the points. |
A preview of the chart appears, as you select your options.
9. Under Chart Type, click on a chart type to select it.
Note: By default, pie and dial charts display in "animated" Flash mode. You can turn animation off by disabling the Animated check box in the Chart Designer. Animated charts bring focus to important aspects of your data. For example, animation allows you to bring out a data point if it reaches a critical value, such as high or low sales numbers.
If you selected a pie or dial chart, see the sections below: Working with Pie Charts or Working with Dial Charts, respectively.
10. Under Theme, select a theme from the list. The theme is applied to your chart.
11. Enter the labels for the Chart Title, X Axis Title (horizontal axis), and Y Axis Title (vertical axis). Entries are displayed in the chart preview.
12. Click Apply to see the chart preview.
13. Click OK display your chart in the dashboard panel.
