Advanced Line Chart Widget


Apps - Widget - Advanced Line Chart icon.png This widget belongs to the Dashboards category in the widget library. It enables you to represent, for a given measure, the trend as segments of straight lines with different dimension values. It is particularly suitable for chronological dimensions.

You can use numerous properties to format the chart, e.g. display and format the chart title and axes, define the position of the legend, use the color palette, format axis labels, display tooltips, etc.

Examples

You want to represent the number of incidents per working day over the past six weeks

CSV file data

  • Dimension = 6 weeks
  • Measure = Number of incidents
    Note: The data source contains several measures. You select the measure you want (working days in the week) using the Data Transformer.
             Download Zip icon.png  Download Example (CSV file)

Different displays in line charts

Background color - Tooltips - Horizontal gridlines - Staggered dimension labels Display in 3D with an impression of depth - Horizontal and vertical gridlines
Advanced line chart - Example 1.png Advanced line chart - Example 2.png

Notes

  Open url.png See General remarks on widgets.

  • The number of lines is identical to the number of dimension elements. Each line is displayed in a different color indicated in the legend.
  • The scale of the measure axis can be defined manually. By default, it starts at 0 and continues up to the maximum value of the selected measures. 
  • The legend can be used as a dynamic data filter in execute mode. To use it, click the label.

Best Practice big icon.pngBest practice

  • You should use this chart to highlight the amount of time or the variation rate.
  • To highlight differences in variation or in volume for each measure, we recommend you use the Advanced Area Chart widget.
  • Select the measures you want using the Data Transformer. If you do not do so, they will all be included.
  • If your data source contains numerous measures and dimensions, your chart will be difficult to read. If this is the case, you should only select the most important measures.
  • If there is little variation in your data, the lines may overlap and, as such, be difficult to read. If this is the case, you should only select the most important measures.
  • To improve the readability of different ranges within the measure axis, you can increase the height of the widget.

List of properties

Content

DataSource

Data Source: External data source associated with the widget. 

  • The drop-down list displays all of the data sources available in the app. 
  • To modify the data source or to view its contents, you should click Apps - Edit icon.png. The Apps - datasources Properties - Preview button.png button below the Preview property shows the number of rows (max. 15) and columns extracted.
  • To define a new data source, click Apps - Add datasource icon.png Add Data Source in the Objects pane.
DataTransformer

Data Transformer: Used to define the structure and scope of the data source, apply statistical aggregate functions and modify the order of the measures displayed.

  • Click Setup / Preview Data below the Data Transformer property to open the dedicated window. Open url.png See the description.
EnableDrilldown

Enable Drilldown (Note: Only for an EasyVista data source data source using a view with grouping levels): Used to indicate if data is aggregated (box is checked - the drill-down functionality is enabled) or not (box is not checked).
         Example documentation icon EN.png  Breadcrumbs widget: Breakdown of equipment by location.

Best Practice icon.png

  • If you want the widget to display the breakdown in a grouping level, you should not check this box.
  • Add a Breadcrumb widget to facilitate navigation within grouping levels.

Data

SortByValueDescending

Sort By Value Descending: Used to sort dimension elements in descending order (if the box is checked, from highest to lowest value) or in the order in which they are read in the data source (box is not checked). Note: The order applied is determined by the dimension elements of the first measure in the data source.

Example documentation icon EN.png    You want to display the chart for incidents and requests per employee

The data source contains the Department dimension with three elements. Sort By Value Descending - Example - Datasource.png

Box is checked Box is not checked

Sort By Value Descending - Example - Sort value - On.png

The dimension elements of each measure are sorted in descending order.

Sort By Value Descending - Example - Sort value - Off.png

The dimension elements of each measure are displayed according to the sort order of the data source.

FirstRowContainsDimensionElements

First Row Contains Dimension Elements: Used to specify the structure of the data source by indicating if dimension elements are found in the first column (box is not checked: standard data source structure) or in the first row (box is checked). Note: This property does not affect the behavior of the Data Transformer.

MaximumNumberOfData

Maximum Number Of Data: Used to indicate the maximum number of dimension elements to be loaded from the data source for each measure selected in the data source.

Best Practice icon.png  You should use this property to prevent loss of performance when data volume is large.

  • The count is always performed from the first dimension element.
  • When the number of dimension elements to be loaded is greater than the number of dimension elements in the data source, all of the data is loaded.
  • To view the data source, click Apps - Edit icon.png next to the Data source property, then click Apps - datasources Properties - Preview button.png button below the Preview property which shows the number of measures and the number of dimension elements for each measure.

Example documentation icon EN.png    You want to display the chart for incidents and requests per employee

The data source contains the Department dimension with three elements. Sort By Value Descending - Example - Datasource.png

  • Maximum Number Of Data = 20 (default value)
  • Maximum Number Of Displayed Data = 20 (default value)
  • Maximum Number Of Data = 2
  • Maximum Number Of Displayed Data = 20 (default value)
  • Maximum Number Of Data = 20 (default value)
  • Maximum Number Of Displayed Data = 1

Sort By Value Descending - Example - Number Data - All.png

All dimension elements are loaded and displayed for each measure, i.e. the three departments.

Sort By Value Descending - Example - Number Data - Part.png

Only the first two dimension elements are loaded and displayed for each measure, i.e. the first two departments.

Sort By Value Descending - Example - Displayed Data - Part.png

All dimension elements are loaded but only the first element is displayed. This corresponds to the Sales department. The Others dimension element groups values from the Marketing and Administration departments.

MaximumNumberOfDisplayedData

Maximum Number Of Displayed Data: Used to indicate the maximum number of dimension elements to be displayed for each measure selected in the data source. This improves chart readability.

Example documentation icon EN.png You want to display the chart for incidents and requests per employee. Open url.png See the Maximum Number Of Data field.

  • The count is always performed from the first dimension element.
  • When the number of dimension elements to be displayed is less than the number of dimension elements to be loaded, the Others dimension element will automatically be added to the chart. It will aggregate all of the values from non-displayed dimension elements.

Charts

AdvancedDashboards_Charts_3Dimensions

3D: Used to indicate if the chart should be displayed in 3D with an impression of depth (box is checked) or in 2D (box is not checked).

X Axis

AdvancedDashboards_XAxis

Axis Position: Position of the dimension axis. Note: The name of the axis is also affected by the position.

  • Top: The axis is placed at the top of the chart and the name appears above the axis.
  • Bottom: The axis is placed at the bottom of the chart and the name appears below the axis.
Name above the axis (Top option) Name below the axis (Bottom option)
Apps - widgets Advanced Dashboards - X Axis position top.png Apps - widgets Advanced Dashboards - X Axis position bottom.png

Axis Color (Inherit): Color of the dimension axis.
 

Tickmarks Color (Inherit): Color of tickmarks in the dimension axis.

         Apps - widgets Advanced Dashboards - X Axis colors.png
 

Display Axis Name: Used to indicate if the name of the dimension axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.

  • The name appears above or below the chart depending on the value specified in Axis Position.
Axis name displayed above the chart (box is checked and Axis Position = Top) Axis name displayed below the chart (box is checked and Axis Position = Bottom)
Apps - widgets Advanced Dashboards - X Axis name - Position top.png Apps - widgets Advanced Dashboards - X Axis name - Position bottom.png
  • Define the display format of the axis name, e.g. font, background color, text color, etc.
    PageGeneralFormat
    Font Family (Inherit) Font of the text, selected via Select Font Graphic properties - General format.png
    Size Font size, selected via the slide or specified directly in the field
    Alignment (Inherit) Alignment of the text (Left/Center/Right/Justified)
    Style (Inherit) Font style of the text Bold/Italic/Underline)
    Background Color (Inherit) Background color of the widget
    Text Color (Inherit) Color of the text displayed by the widget

    Note: Priority is given to the font and color defined using the text editor

X Axis Label

AdvancedDashboards_XAxisLabel

Display Axis Label: Used to indicate if the measure axis labels should be displayed (box is checked) or not (box is not checked). The labels are from the data source.
         Apps - widgets Advanced Dashboards - X Axis label.png

  • Define the display format using the properties below.
     

Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single row. To display all labels over two rows, you can stagger them by checking this option.

Display in one row (box is not checked) Staggered display over two rows (box is checked)
Apps - widgets Advanced Dashboards - X Axis label.png Apps - widgets Advanced Dashboards - X Axis label - Stagger on.png

Note: To display all labels in a single row, you can also:

  • Rotate them using the Is Rotate property.
  • Truncate the labels using the Label Length property.

Label Length (Note: Only if the Display Axis Label box is checked): Used to indicate if the dimension axis labels should be truncated (box is checked) or not (box is not checked). If you want to truncate them, you should enter the number of characters for each label in Truncate Value.

Truncated labels (box is checked and Truncate value = 4) Non-truncated labels (box is not checked)
Apps - widgets Advanced Dashboards - X Axis Label length on.png Apps - widgets Advanced Dashboards - X Axis Label length off.png

Note: The Is Rotate property is enabled.

Is Rotate (Note: Only if the Display Axis Label box is checked): Used to indicate if the dimension axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).

  • A negative value rotates text to the right.
  • A positive value rotates text to the left.
  • When the value is zero, labels are not rotated.

         Apps - widgets Dashboards - X Axis label rotate value.png

PageGeneralFormat
Font Family (Inherit) Font of the text, selected via Select Font Graphic properties - General format.png
Size Font size, selected via the slide or specified directly in the field
Alignment (Inherit) Alignment of the text (Left/Center/Right/Justified)
Style (Inherit) Font style of the text Bold/Italic/Underline)
Background Color (Inherit) Background color of the widget
Text Color (Inherit) Color of the text displayed by the widget

Note: Priority is given to the font and color defined using the text editor

X Lines

AdvancedDashboards_XLines

Display Lines: Used to indicate if horizontal gridlines should be displayed (box is checked) or not (box is not checked). These horizontal gridlines are parallel to the dimension axis.

  • Note: The display of gridlines improves chart readability. In 3D charts, gridlines are displayed in depth.
  •  You can modify the color of gridlines in Color.

         Apps - widgets Advanced Dashboards - X Lines on.png

Y Axis

Left Axis

AdvancedDashboards_YLeftAxis_AxisPosition

Axis Position: Position of the measure axis.
Note: The name of the axis is also affected by the position.

  • Left: The axis is placed to the left of the chart and the name appears to the left of the axis.
  • Right: The axis is placed to the right of the chart and the name appears to the right of the axis.
Name left of the axis (Left option) Name right of the axis (Right option)
Apps - widgets Advanced Dashboards - Y Axis position left.png Apps - widgets Advanced Dashboards - Y Axis position right.png
AdvancedDashboards_YLeftAxis

Min Value: Minimum start value of the scale of the measure axis.

  • By default, the scale will start with the lowest value in the data source, rounded down to the nearest tenth.
             Example documentation icon EN.png  22 ==> 20
     

Max Value: Maximum end value of the scale of the measure axis.

  • By default, the scale will end with the highest value in the data source, rounded up to the nearest tenth.
             Example documentation icon EN.png  42 ==> 50
Default values Values specified manually (min = 27; max = 45)
Apps - widgets Advanced Dashboards - Y Axis - Min max values - off.png Apps - widgets Advanced Dashboards - Y Axis - Min max values - on.png

Axis Color (Inherit): Color of the measure axis.
 

Tickmarks Color (Inherit): Color of tickmarks in the measure axis.

         Apps - widgets Advanced Dashboards - Y Axis colors.png
 

Display Axis Name: Used to indicate if the name of the measure axis should be displayed (box is checked) or not (box is not checked). If you want to display it, you should enter the title in Axis Name.

  • The name appears to the left or right of the chart depending on the value specified in Axis Position.
Axis name displayed left of the chart (box is checked and Axis Position = Left) Axis name displayed right of the chart (box is checked and Axis Position = Right)
Apps - widgets Advanced Dashboards - Y Axis name - Position left.png Apps - widgets Advanced Dashboards - Y Axis name - Position right.png
  • Define the display format, e.g. font, background color, text color, etc.
    PageGeneralFormat
    Font Family (Inherit) Font of the text, selected via Select Font Graphic properties - General format.png
    Size Font size, selected via the slide or specified directly in the field
    Alignment (Inherit) Alignment of the text (Left/Center/Right/Justified)
    Style (Inherit) Font style of the text Bold/Italic/Underline)
    Background Color (Inherit) Background color of the widget
    Text Color (Inherit) Color of the text displayed by the widget

    Note: Priority is given to the font and color defined using the text editor

Data Type: Used to define the display format of values in the measure axis and in tooltips (Common > Tooltip section). Note: The number format, e.g. comma or period for the decimal symbol, depends on the configuration settings of the platform used by the logged-in user. In Windows, this is specified in the Control Panel > Regional and Language Options.

  • Integer: Whole numbers rounded up or down to the nearest unit.
             Example documentation icon EN.png  152200.87 ==> 152201
  • Float: Values with 2 decimals
             Example documentation icon EN.png  152200.87 ==> 152200.87

Left Axis Label

AdvancedDashboards_YLeftAxisLabel

Stagger Mode (Note: Only if the Display Axis Label box is checked): Based on the device size, e.g. smartphone, tablet, etc., certain labels may be omitted in order to display a single column. To display all labels over two columns, you can stagger them by checking this option.

Display in one column (box is not checked) Staggered display over two columns (box is checked)
Apps - widgets Advanced Dashboards - Y Axis label.png Apps - widgets Advanced Dashboards - Y Axis label - Stagger on.png

Note: To display all labels in a single column, you can rotate them using the Is Rotate property.

Is Rotate: Used to indicate if the measure axis labels should be rotated (box is checked) according to the angle defined in Rotate Value or if they should be displayed horizontally (box is not checked).

  • A negative value rotates text to the bottom.
  • A positive value rotates text to the top.
  • When the value is zero, labels are not rotated.

         Apps - widgets Dashboards - Y Axis label rotate value.png
 

Prefix: Alphanumeric value added to the start of each label in the measure axis.

         Example documentation icon EN.png  Labels preceded by the measure unit

  • Prefix = M 
  • Label = 150
    ==> value displayed: M 150

Suffix: Alphanumeric value added to the end of each label in the measure axis.

         Example documentation icon EN.png  Labels ended with the measure unit

  • Suffix = K 
  • Label = 150
    ==> value displayed: 150 K

         Apps - widgets Advanced Dashboards - Y Axis label - Prefix suffixe.png

PageGeneralFormat
Font Family (Inherit) Font of the text, selected via Select Font Graphic properties - General format.png
Size Font size, selected via the slide or specified directly in the field
Alignment (Inherit) Alignment of the text (Left/Center/Right/Justified)
Style (Inherit) Font style of the text Bold/Italic/Underline)
Background Color (Inherit) Background color of the widget
Text Color (Inherit) Color of the text displayed by the widget

Note: Priority is given to the font and color defined using the text editor

Y Lines

AdvancedDashboards_YDisplayLines

Display Lines: Used to indicate if vertical gridlines should be displayed (box is checked) or not (box is not checked). These vertical gridlines are parallel to the measure axis.

  • Note: The display of gridlines improves chart readability. In 3D charts, gridlines are displayed in depth.
  •  You can modify the color of gridlines in Color.

         Apps - widgets Advanced Dashboards - Y Lines on.png

Common

AdvancedDashboards_Common_General

Animation: In execute mode, this is used to indicate if the chart should be displayed in dynamic mode (box is checked) or in static mode (box is not checked). In dynamic mode, elements are displayed one after the other while in static mode, they are displayed at the same time.
 

AdvancedDashboards_Common_DisplayPrintExportButton

Display Print and Export Button: Used to indicate if users can save and print the chart (box is checked) or not (box is not checked). If users can save and print it, the Save icon.png and Print icon.png icons will appear. Note: The icons are always displayed to the right of the chart.

  • Save icon.png : Used to save the chart in a JPG file.
  • Print icon.png : Used to print or save the chart in a PDF file.
             Apps - widgets Advanced Dashboards - Common display print export buttons.png

 

AdvancedDashboards_Common_DisplayAreaColor

Display Area Color: Used to indicate if a specific color should be applied to the background (box is checked) or not (box is not checked). If you want a background color, you should select it in Chart Area Color.

  • The area of the background is delimited by the dimension axis and the measure axis.
  • To apply a background color to the entire chart, use the Theme > Background Color property. The background color defined in the Display Area Color property will have priority.
     
Background color defined (box is checked) White background (box is not checked) Background color for the entire chart (Theme property)
Apps - widgets Advanced Dashboards - Common display area color on.png Apps - widgets Advanced Dashboards - Common display area color off.png Apps - widgets Advanced Dashboards - Common display area color on - Background theme.png

Title

AdvancedDashboards_Common_DisplayChartTitle

Display Chart Title: Used to indicate if a title should be added to the chart (box is checked) or not (box is not checked). If you want to add a title, you should enter it in Chart Title and define its format.
         Apps - widgets Advanced Dashboards - Common - Chart title.png

Display format of the chart title, e.g. font, background color, text color, etc.

PageGeneralFormat
Font Family (Inherit) Font of the text, selected via Select Font Graphic properties - General format.png
Size Font size, selected via the slide or specified directly in the field
Alignment (Inherit) Alignment of the text (Left/Center/Right/Justified)
Style (Inherit) Font style of the text Bold/Italic/Underline)
Background Color (Inherit) Background color of the widget
Text Color (Inherit) Color of the text displayed by the widget

Note: Priority is given to the font and color defined using the text editor

Labels Points on the Graph

AdvancedDashboards_Common_DisplayPointLabel

Display Point Label: Used to indicate if data labels in the chart should be displayed (box is checked) or not (box is not checked). If you want to display data labels, select the information to be displayed from the Label list.

  • By default: Value of the dimension axis followed by the value of the measure axis.
  • Define the display format, e.g. font, background color, text color, etc.
     

Label  (Note: Only if the Display Point Label box is checked): Information displayed in the chart.

  • Name: Values of the dimension axis.
  • Value: Values of the measure axis.
  • Click x to return to the default option where the two values are displayed.
Default display Values of the dimension axis

(Name option)

Values of the measure axis

(Value option)

Apps - widgets Advanced Dashboards - Common display label points - Name and value.png Apps - widgets Advanced Dashboards - Common display label points - Name.png Apps - widgets Advanced Dashboards - Common display label points - Value.png

Position: Position of data labels in the chart.

  • Inside of the Chart: Within the chart.
  • Outside of the Chart: Outside the chart.

    Best Practice icon.png You should use this option when information tends to overlap within the chart. This will provide more space for longer data labels.

Within the chart (Inside option) Outside the chart (Outside option)
Apps - widgets Advanced Dashboards - Common display label point - Inside.png Apps - widgets Advanced Dashboards - Common display label point - Outside.png

Display format of the data labels, e.g. font, background color, text color, etc.

PageGeneralFormat
Font Family (Inherit) Font of the text, selected via Select Font Graphic properties - General format.png
Size Font size, selected via the slide or specified directly in the field
Alignment (Inherit) Alignment of the text (Left/Center/Right/Justified)
Style (Inherit) Font style of the text Bold/Italic/Underline)
Background Color (Inherit) Background color of the widget
Text Color (Inherit) Color of the text displayed by the widget

Note: Priority is given to the font and color defined using the text editor

Color Palette

AdvancedDashboards_Common_ColorPalette

Chart Color: Color palette applied to the chart. This is used to define the color of chart data and the color of legend buttons.

  • The list is provided by Logo - EasyVista.png
  • The number of colors in the palette is indicated next to its name, e.g. Brown (6), Default (12), EasyVista (7).
  • The color of other chart elements, e.g. axis title and labels, chart title and tickmarks, are defined using specific properties.

         Apps - widgets Advanced Dashboards - Common - Chart color palette.png

Legend

AdvancedDashboards_CommonLegend

Display Legend: Used to indicate if the chart legend should be displayed (box is checked) or not (box is not checked).
         Apps - widgets Advanced Dashboards - Common display legend.png

  • Each legend is made up of the name of the dimension element preceded by a button.
  • The color of the buttons is defined by the color palette applied to the chart (Common > Color Palette property).
  • Define the position of the legend using the Layout, Position, Horizontal and Vertical properties. Caution: Depending on the selected options, the chart will automatically be resized to allow legends to be fully displayed.
  • Note: The legend can be used as a dynamic data filter in execute mode. When you click a button or name, you can display or hide the corresponding values in the chart.
     

Display Legend Title (Note: Only if the Display Legend box is checked): Used to indicate if a title should be added above the chart legend (box is checked) or not (box is not checked).

         Apps - widgets Advanced Dashboards - Common - Legend title.png
 

Layout (Note: Only if the Display Legend box is checked): Orientation of the chart legend.

  • Horizontal: Legend labels are displayed horizontally, adjacent to each other.
  • Vertical: Legend labels are displayed vertically, one below the other.
Legend in rows (Horizontal option) Legend in columns (Vertical option)
Apps - widgets Advanced Dashboards - Common legend - layout horizontal.png Apps - widgets Advanced Dashboards - Common legend - layout vertical.png

Properties for the legend position (Note: Only if the Display Legend box is checked).

See the summarized layouts

  • Vertical alignment (Layout = Vertical)

    Apps - widgets Advanced Dashboards - Schema legend position - Layout vertical.png

  • Horizontal alignment (Layout = Horizontal)

    Apps - widgets Advanced Dashboards - Schema legend position - Layout horizontal.png

Position: Position of the legend within the chart.

  • Top: At the top of the chart.
  • Bottom: At the bottom of the chart.
  • Left: To the left of the chart.
  • Right: To the right of the chart.
     

Horizontal Align (Note: Only if Position = Top or Bottom): Horizontal position of the chart legend.

  • Left: To the left of the chart.
  • Center: In the center of the chart.
  • Right: To the right of the chart.
     

Vertical Align (Note: Only if Position = Left or Right): Vertical position of the chart legend.

  • Top: At the top of the chart.
  • Center: At the top of the chart.
  • Bottom: At the bottom of the chart.

Tooltip

AdvancedDashboards_CommonTooltip

Display Tooltip: Used to indicate if data labels should be displayed in a tooltip when the cursor hovers over the chart (box is checked) or not (box is not checked). If you want to display tooltips, select the information to be displayed from the Label list.

  • Information displayed by default when the cursor hovers over each data point: Value of the dimension axis / Value of the measure axis
  • Define the display format using the properties below.

         Apps - widgets Advanced Dashboards - Common display tooltip on.png

Tooltip Display Mode (Note: Only if the Display Tooltip box is checked): Used to define the information displayed when the cursor hovers each data point.

  • Single: Value of the dimension axis / Value of the measure axis
  • Union:  Value of the dimension axis / All values of the measure axis
Current value of the measure axis (Single option) All values of the measure axis (Union option)
Apps - widgets Advanced Dashboards - Common display tooltip on - Single.png Apps - widgets Advanced Dashboards - Common display tooltip on - Union.png

Position (Note: Only if the Display Tooltip box is checked): Position of the data point's tooltip based on the movement of the cursor.

  • Float: The tooltip will move along with the cursor.
  • Point: The tooltip always appears above the data point regardless of the position of the cursor.

Theme

    Open url.png See the description of properties.

Tags:
Last modified by Unknown User on 2019/04/01 20:17
Created by Administrator XWiki on 2019/04/01 20:09

Shortcuts

Powered by XWiki ©, EasyVista 2020