Creating a real time chart

A real time chart can be updated automatically at runtime by using data that changes rapidly with time such as stock market quotes. After you create a real time chart, when the data in the data source the chart uses is updated in real time, the chart will automatically fetch data from the data source to update itself with the interval you specify. Then, you will conveniently see the real time data information without updating the chart by yourself and without having to re-fetch all of the data. Only the new data since the last interval is selected by the query.

Before you create a real time chart, you have to make sure the data source you use contains real time data which can be updated periodically. Otherwise, the chart will lose its real time meaning.

Currently, real time charts are supported on web reports and library components only.

To insert a real time chart into a web report or a library component:

1. Position the mouse pointer at the destination where you want to insert the chart.
2. Do one of the following to open the Create Chart wizard:
   • Click Insert > Chart on the menu bar.
   • Click the Insert Chart button on the Insert toolbar.
   • Drag Chart from the Toolbox panel to the destination.
3. In the Data screen of the wizard, select a business view in the current catalog on which the chart will be created.
4. In the Type screen, specify the type of the chart which can only be single chart of bar, bench, line, or area type.
5. In the Display screen, specify a title for the chart in the Title text field. Check the Real Time checkbox.
6. By default, Use System Time for Category is checked and you can see the text Use System Refresh Time is displayed in the Category box, which means the time at which the chart refreshes itself will be used as the category value. You can uncheck the Use System Time for Category option and add another field to be displayed on the category (X) axis, and define the Order/Select N condition on the field if required. Then, add the fields of numeric type which cannot be summary fields to the Show Values box.
7. Specify the time interval at which the chart will get data and refresh itself automatically in the Refresh Interval text field.
8. Specify the most recent N records to be kept for the real time data on the chart in the Show Most Recent text field.
9. Click the Incremental Fetch button to add the fields you want to use as the unique key of the real time chart in the Unique Key dialog.

   Once a unique key is defined, each time when the real time chart automatically updates itself, duplicated data records will be filtered out based on the unique key. For instance, if you add the fields Country and Product ID as the unique key of a real time chart, when a record with the product ID 1 in USA has already been loaded into the chart, no more records of this product ID in USA will be added to the real time chart because they have the same unique key value.

10. To apply some filters to the chart so as to reduce the data displayed in the chart, go to the Filter screen and define the filter conditions.
11. In the Layout screen, specify the layout of the chart.
12. In the Style screen, select a style for the chart.
13. Click Finish to create the chart.