Chart - Funnel and Pyramid

pie.svg Funnel and Pyramid

General - Funnel and Pyramid

The graph function of DataChain is accessible from HandleData. Logo HandleData

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

This function is used to represent data sources in the form of graphs. Several types of graphs are available.

Funnel and Pyramid Icon Funnel and Pyramid

Like other components, DataChain charts can be integrated into Tableaux de Bords.

Creating a Tunnel or Pyramid Chart

List of graphics

The creation of a chart (like all operations on charts) is performed from the HandleData module. handleData-color.png

Step 1

  • Access HandleData module Logo HandleData

  • 1 Choose, in the left menu HandleData, the option Graphic 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 Tunnel or Pyramid chart choose the icon funnel

  • Each chart 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 graphic.

information It is advisable to save the metadata panel as soon as you enter it. Use the button Save button located in the right part of the top banner of the graphic 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.
The Dates display format must be defined in the third step to be visible in the Viewer.

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 needed, user can make changes to ch sourcesgossip:

    • Added formulas creating new values

    • Generation of filters

    • Sorts

    • Aggregations

  • In this case, select one of the sources assigned to the current graph. Use the icon edit located at the end of the line (or click on source label). Then 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 Tunnel

  • Caption and titles

    • Title: Chart title.

      • Font: Character 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: Color of the chart subtitle.

      • Size: Font size of the chart subtitle.

    • Palette: Color palette associated with the chart.

    • Caption: Specifies whether the caption is visible or not.

      • Frame: Determines the presence of a frame around the legend.

      • Position: Determines the position of the legend, either

        • inside the chart (inside)

        • outside the chart (Away)

      • Orientation: Determines the orientation of the legend, either horizontal or vertical.

      • Vertical alignment: Indicates 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: Determines whether the zoom is active or inactive.

    • Scroll: Determines if the ability to scroll the graph is active or inactive.

    • Export: Determines 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°. The ordinate becomes a horizontal axis and the abscissa becomes a vertical axis.

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

Tunnel and Pyramid Setup

parameterfunnel.svg

  • Inverted: Allows you to invert the direction of the graph.

  • Separation edge: Includes a separation bar between each element of the Tunnel or the Pyramid.

  • Argument: Indicates the column that contains the argument to be taken into account for the graph.

Warning Required

  • Value: Specifies the column that contains the values ​​to be taken into account for the chart.

Warning Required

  • Sort: Performs a sort of values. This sorting has a direct impact on the final graph.

  • Label: Determines whether labels are visible or not.

    • Position: Allows you to determine whether the labels are positioned inside or outside the graph.

    • Alignment: Specifies the horizontal alignment of the labels. Right, Left or Center.

  • Mode: Specifies the display mode. Two possible options

    • Tunnel: Tunnel presentation funnel.svg Tunnel.

    • Pyramid: Presentation in Pyramid pyramid.svg Pyramid.

Tab - Visualization

visualisationfunnel.svg

Display of the graph taking into account all the parameters specified in the configuration screen.

Editing a DataChain chart

  • HandleData module. Logo HandleData Chart Menu 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 graphic label or on the edit icon at the end of the line.

Deleting a chart

Module *HandleData. Logo HandleData 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 chart editing. Click on the Delete button and confirm the action.

Quick Reference

Creation of the Tunnel or Pyramid type graphic funnel.svg Tunnel / Pyramid

From the HandleData genericsData-color module

Steps Objective Stock Landmarks

1

Access to the Charts list

Click on Chart icon

chart-linz

2

New Chart

Click on New icon

New

3

Choose a chart type

Click on the icon

funnel

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