Range Charts (Bar or Area)

bar_range -

General - Range

The graph function of DataChain is accessible from the HandleData module. handleData-color

The number of graphics that can be created is not limited.

This function is used to present data sources in the form of a range-type graph.

range_barre.svg Range

Like the other components, the Range can be integrated into Tableaux de Bords.

Creating a Range chart

List of existing graphics

The creation of a Range chart (like all operations on presentations) is performed from the HandleData module. Logo HandleData

Step 1

  • Access HandleData module Logo HandleData

  • 1 Choose, in the left menu HandleData, the option Chart associated with the icon chart-line

Access to the list of graphics

Metadata

2nd step

  • 2 Click on the button New

  • A screen allows you to choose the type of graph you want. To create a Range type chart, choose the icon range_barre.svg

  • Each graph has a metadata panel. Entering a label is required.

Metadata of a new graphic

Optional input areas allow for more description. An icon can thus be assigned to the metadata of a chart.

information It is advisable to save the metadata as soon as you enter it. Use the button Save button located in the right part of the top banner of the screen.

Tab - Data Sources

Step 3

  • A data source is required to create a chart. Use the btn-ajouter-source.svg[add a source] icon to access the list of available sources (cf DataBlocks documentation).

information The proposed sources are related to the rights of the current user

information It is possible to integrate, on the fly, a file with a separator. To do this, use the Rapid Integration function via the icon Rapid integration icon located in the top banner of the HandleData application.

1 Sources are powered by DataBlocks. It is possible, at the level of each source, to carry out operations making it possible to adapt, for a presentation, the blocks of original data by clicking on the icon Icone edit

2 Displays a succession of operations such as generation of formulas, filters, aggregations, sorting and modification of labels and types are available.

Source Operations Handle Step 4 ::

The list of available sources is presented in the form of a table. In the proposed list, choose one (or more) sources then double-click on the line or use the button Validate to assign the source to the graphic.

Choice of sources

1 Refreshes the list of available sources

2 Validates source assignment. It is necessary, before this operation, to choose a source by selecting a line in the table of sources.

3 Return to the list of sources assigned to the graphic.

Warning Unlike TimeLines or Maps, only one source can be affected

Step 4 Bis (optional)

  • If necessary, the user can make changes to the chosen sources:

    • Added formules creating new values

    • Generation of filters

    • Sorts

    • Aggregations

  • To do this, select one of the sources assigned to the current graph. Use the edit icon located at the end of the line (or click on the source label). Make the necessary changes. Save the changes using the Validate button then the Back button icon to return to the list of sources for the current graph.

Tab - Settings

General

General graphics parameters

  • Caption and titles

    • Title: Chart title

      • Font: Font used for the chart title

      • Color: Chart title color

      • Size: Chart title font size

    • Subtitle: Chart subtitle

      • Font: Character font used for the graph subtitle

      • Color: Chart subtitle color

      • Size: Chart subtitle font size

    • Palette: Color palette associated with the chart

    • Caption: Specifies whether the caption is visible or not

      • Frame: Specifies the presence of a frame around the legend

      • Position: Specifies the position of the legend

        • either inside the graph (inside)

        • either outside the graph (Outside)

      • Orientation: Specifies the orientation of the legend

        • is horizontal

        • is vertical

      • Vertical alignment: Specifies the location of the legend, top (Top), bottom (Bottom) or centered (Center)

      • Horizontal alignment: Specifies the location of the legend, to the right (Right), to the left (Left) or centered (Center)

    • Zoom: Specifies whether the zoom is active or inactive

    • Scroll: Specifies whether the scroll is active or inactive

    • Export: Specifies whether the panel used to export the graph is active or inactive Possible exports are: PNG, JPEG, PDF, SVG and print module

    • Inverted: Rotates the graph by 90°.

    • Tooltip: Allows to define the content of the tooltip. All the columns of the source can be integrated into it.

Presentation Settings Range

Setting up a range type chart

1 Choice of chart type. Two options are possible: * Closed off * Area

2 Parameterization of Abcissas

  • Values: Choice of the column from the data source containing the abscissa values

  • Title: Allows you to assign a title to the abscissa

  • Type: Specifies the Type of the abscissa values

  • Grid: Activates (or Inactivates) the main grid when viewing

  • Minor Grid: Enable (or Disable) the minor grid when viewing

3 Ordinate settings

  • Low value: Column from the data source containing the low values ​​of the ordinate of the main series

  • High value: Column from the data source containing the high values ​​of the ordinate of the main series

  • Title: Allows you to assign a title from the main series

  • Type: Specifies the Type of the abscissa values

  • Color: Allows you to set a color to the main series

4 Add n series of values ​​to the representation

  • Icon btn plus: Add a series

  • Title: Allows you to assign a title from the main series

  • Low value: Column from the data source containing the low values ​​of the ordinate of the main series

  • High value: Column from the data source containing the high values ​​of the ordinate of the main series

  • Color: Color assigned to the series

  • Separate axis: Indicates if the axis of the series is not in common with the main axis of the ordinates

  • Aggregation: Operations to be performed in case of on-the-fly aggregation

Tab - Visualization

Allows viewing of the Range taking into account all the parameters specified in the settings screen.

visu_range

Editing a DataChain chart

  • Module HandleData.Logo HandleData

  • Chart menu Icon Chart line

  • At the level of the list of graphics, search for the graphic. it is possible to use the search and sort functions present at the level of each column.

  • Select line

  • Click on the graph label or on the edit icon at the end of the line

Deleting a chart

  • HandleData module. Chart menu chart-line

  • At the level of the list of graphics, search for the graphic to be deleted. it is possible to use the search and sort functions present at the level of each column.

  • Select line

    • Option 1: Use the button icon suppression at the end of the line and confirm the action.

    • Option 2:

      • Click on the graphic label or on the edit icon at the end of the line.

      • Once in Graphic editing, click on the Delete button and confirm the action

Quick Reference

Creation of a Range chart range_barre.svg

From HandleData module Logo HandleData

Steps Objective Stock Landmarks

1

Access to the list of graphics

Click on Chart icon

chart-line

2

New Chart

Click on New icon

New

3

Choose a Range Bar chart type

Click on the icon

range_barre.svg

4

The metadata

Enter information

Description Required

5

Assigning a source

Click on New source icon

Add source

6

Chart settings

Click on the Settings tab

7

Visualization of the graph

Click on the Visualization tab