Settings

The Function Flow diagram requires a column for the Start function, End function, and the Relevance value respectively. Additionally, you can define further connection values in the optional list field Additional connection values. These values are available in the settings menu in the Function Flow diagram, and the value order corresponds to the order in the list field. The fields Function names and Function measure value are used to display function measures in the Function Flow diagram.

By default, you can change the Display name and the Format of the relevance and connection values. By changing the Sorting of the relevance column you can set the assessment of the connections. If you select Ascending, high values are considered positive (for example, revenue). If you select Descending, low values are considered positive (for example, costs).

The widget allows you to use the same column for the Relevance, Additional connection, and Function measure widget elements without changing the name. If the widget elements use the same columns but different aggregation types, you must assign different names to the individual widget elements.

Option list

Field

Description

Start function

Contains the column of the start nodes. These nodes are used as a starting point for the connections and a connection is drawn to the end node.

This field is required and only allows unique text columns.

If the field is empty, no graph is displayed.

End function

Contains the column of the end nodes. These nodes are used as a target point for the connections and a connection is drawn from the start node to the end node.

This field is required and only allows unique text columns.

If the field is empty, no graph is displayed.

Relevance value

Contains the column of the relevance values. The relevance value calculates the thickness of the connections, if enabled. The sorting of the relevance can be changed via a property.

This field is required and only allows numeric columns which are not already used as additional connection value.

If the field is not filled, no graph is shown.

Additional connection values

Can be used to define additional values that can be displayed on connections. The order determines the order in the later selection box. The box can be used to switch between these values.

This field is optional and only allows numeric columns which are not already used as relevance value.

Function names

Contains the column of all function names. It has to be a column other than the start or end function because the start function misses nodes without outgoing connections & end function misses nodes without incoming connections and therefore not all required function names are contained in these columns.

This field is optional and only allows numeric columns even if they are used as relevance value or additional connection value.

It is used to display function measures.

Function measure value

Contains the column of the function measure values. The data of the column is displayed as a function measure within the function boxes. It is only possible to display one value for the function measure.

Optional,

Numeric columns only,

It is used to display function measures.

Advanced options

Field

Description

Display name

New column name displayed in the widget, for example, used for KPI, data points or tool tips. By default, the data source column name is used.

Aggregation

Specifies how the KPI value is calculated. Available for numeric columns. Default is Average value.

The number of aggregation types provided by context-based widgets may differ from that of non-context-based widgets.

Format

Output format of the column values, for example, used for data points or tool tips. Available for columns of date and numeric type.

Round Numerically

Displays rounded measure values in the chart. Available for numeric columns. Enabled by default.

Sorting

Sorts the values of the selected element in ascending or descending order.