Data definition

<< Click to Display Table of Contents >>

Navigation:  Charts > Line chart wizard >

Data definition

Previous pageReturn to chapter overviewNext page

On this page you can assign columns of the data source to X and Y-axis, set their data format and choose how data are assigned to curves.

 

clip0134

 

X-Axis
Select the column that contains the data which should be displayed on X-axis.
The select box offers columns of integer, date, time or timestamp types.

 

X-Format
This field is enabled only when the type of X-axis column is defined as Integer on the server.
In this case you can set how integer values in this column are formatted.
The select box offers columns of integer or time types.

 

Y-Axis
Select the column that contains the data which should be displayed on Y-axis.

 

Y-Format
This field is enabled only when the type of Y-axis column is defined as Integer on the server.
In this case you can set how integer values in this column are formatted.

 

Start time
This field is enabled only if the Y-axis has time format (defined on the server or set in Y-Format field for integer values).
In this case it defines the minimal value on the Y-axis. The default time is 00:00 and the maximal width of the whole Y-axis is always 24 hours in the time mode.
Values lower than Start time are handled like the times of the next day.

 

Curves in the chart
If Single curve option is selected then all data of the data source are used for creating the single curve.
If More option is selected then more curves can be created. In this case select the column which determines the curve.

 
 

You can also create virtual columns and assign them to X or Y axis. Virtual columns are useful in cases when the important information for X axis or Y axis is stored only as a part of another value.

For example, you can have a time stamp value stored in some column and you want to assign the time to X axis and the date to Y axis. To do it you have to split the time stamp into two fields - one containing the time, the other one the date. The following picture shows it:

 

clip0143

 

Press New to add a new virtual column. A window where the column is defined opens:

 

clip0144

 

 

Name

A name of the new column.

 

Based on

The source column (must have time stamp format in this particular sample).

 

Function

The function which returns the desired data. Supported functions are:

Left(x)        returns x leftmost characters

Right(x)        returns x rightmost characters

Mid(x,y)        returns a substring of length y starting at position x.
 

The function is always called on data in the raw format (not formatted one). All date-time values are sent by the server in YYYYMMDDHHMMSSttttt format (or parts of it).

Therefore, to extract the date use LEFT(8) function. To extract the time use MID(8,6) function.

 

Format

The format of the new column.