Configure a Real-Time Line Chart

Appendix : Legacy Presto components : Mashables and Mashups : Views for Mashups and Mashables : Built-in MashZone NextGen Views : Real-Time Line Chart : Configure a Real-Time Line Chart

The configuration wizard opens with the first step to Select a Data Source. Then, you can:

Define Date Columns

Assign Columns to Axes

Set Column Properties

Set Chart Properties

Select a Data Source

To find and select the event mashable or Apama mashable that you want to use as the data source for this chart, either:

Select the event source for the mashable you want from the list and click Next.

Enter part of the name for the event source to filter the list. Select the event source you want and click Next.

Select a Data Source

To find and select the event mashable or Apama mashable that you want to use as the data source for this chart, either:

Select the event source for the mashable you want from the list and click Next.

Enter part of the name for the event source to filter the list. Select the event source you want and click Next.

Define Date Columns

If none of the columns for this event or Apama mashable are dates or times, click Next.

Note:

Date configuration information is not required for the Event_LastUpdateTime_Internal column included in Apama mashable events.

If there are columns that are dates:

1. Set the Date option for that column.

If the data for this column is numeric, Business Analytics treats this as the number of milliseconds since January 1, 1970 to determine a date and time.

2. If the data for a date column is text, you must also:

a. Enter a pattern as the Format for this data to allow Business Analytics to correctly interpret the date. Use the following characters to define the pattern:

Character	Meaning
y or Y	Year If the data contains a four digit year, the format pattern can contain any number of y characters to recognize the year component of the date. If the data contains only a one or two digit year, a format pattern of yy returns a four digit year while a format pattern of yyyy returns just the year.
M	Month If the date has a text abbreviation of the month, use MMM as the format pattern. If the month is numeric, use MM or M as the format pattern.
d or D	Day
h or H	Hour
m	Minute
s or S	Second or Milliseconds
a or A	AM/PM
- or /	As the date component separator
:	As the time component separator
space or other literals	Can be used within the format pattern and appear exactly as typed.

b. Select the Language for this data.

3. Once you have identified all columns that are dates or times, click Next.

Assign Columns to Axes

You assign event columns to the axes of the chart and optionally partition events into subcategories to determine how event data will be plotted in the chart. To assign a column, select one of the columns from the list on the left and drop it into a field. To delete a column drag the column out of a field and drop it.

With measure columns that you assign to the Y axis, you must also choose an aggregate function to apply to the measure: Sum, Min, Max, Avg or Count.

There are three patterns you can follow to assign columns:

Dynamic Time Line for One or More Measure Across All Events aggregates and plots all events along a growing time line, as events occur. Each measure you choose to include generates one line.

To create a dynamic time line across all events:

Assign a date column to the X-axis.

For Apama mashables, this is the Event_LastUpdateTime_Internal column.

Assign one or more numeric columns to the Y-axis. Choose an aggregate function to apply to each column to determine how event data is combined.

Skip the Partition field.

Dynamic Time Line for One Measure Partitioned by Category plots all events on a growing time line. Events are partitioned by a category, each unique category is plotted as a separate line for one measure.

To create a dynamic, partitioned time line chart:

Assign a date column to the X-axis.

For Apama mashables, this is the Event_LastUpdateTime_Internal column.

Assign a single numeric column to the Y-axis and choose the aggregate function to apply.

Assign a text column to the Partition field. This column defines the partitions.

Dynamic Categories plots event data across categories on the X axis. There is no timeline, but as events occur, the lines on the chart are completely replotted.

For example, you can plot temperature, humidity and other weather measures for different cities using the Apama Weather sample. The category is city.

To create a dynamic categories chart:

Assign a text column to the X-axis. The unique values of this column represent one point on the line.

Assign one or more numeric columns as measures to the Y-axis. Each column generates a separate line.

Choose an aggregate function to apply to each measure.

Skip Partition.

Set Column Properties

You can change labels and visual formats for any column:

Set a New Name to change the label that appears in tooltips and the chart legend, if any.

Select a Format pattern for numeric or enter a pattern for date columns. You can:

Choose a pattern to set the decimal and thousand place separators as well as the total number of decimal places for numeric columns.

For example, choose:

1,234.56

To see numbers with two decimal places, a period as the decimal point and a comma as the thousand separator.

Set the format and separators to use with dates and times.

Use these symbols:

Character	Meaning
y or Y	Year If the data contains a four digit year, the format pattern can contain any number of y characters to recognize the year component of the date. If the data contains only a one or two digit year, a format pattern of yy returns a four digit year while a format pattern of yyyy returns just the year.
M	Month If the date has a text abbreviation of the month, use MMM as the format pattern. If the month is numeric, use MM or M as the format pattern.
d or D	Day
h or H	Hour
m	Minute
s or S	Second or Milliseconds
a or A	AM/PM
- or /	As the date component separator
:	As the time component separator
space or other literals	Can be used within the format pattern and appear exactly as typed.

Turn on rounding for numeric columns to round values to zero decimals.

Click Next.

Set Chart Properties

Finally, set general properties for the chart including:

Enter a Chart title if desired.

Change the default value of the X-axis name to display a label for this axis. This defaults to the label for the column assigned to this axis.

You can also delete the value to remove this label from the chart.

Change the default value of the Y-axis name to display a label for this axis. If you assigned a single measure to this axis, this defaults to the label for that measure. If there are multiple measures for this axis, the label defaults to Value.

You can also delete the value to remove this label from the chart.

Choose the Line type:

Linear

Curved

Step-after

Set Legend to display a legend for the chart.

Click Save. The chart begins to plot data and updates periodically as events occur.

Contact Support | Community | Feedback