Chart

This view element allows values of an application to be graphically displayed. The chart control provides many different templates, enables the number of data records to be limited, the integration of dependencies, the manipulation of all chart properties, and the ability to export charts as jpg, png, svg, and pdf.

The "Diagram" application element is part of the "Images and files" element category.

The diagram element can be found in the "Elements" section of the "Applications" module. A new diagram can be created by dragging and dropping the element from here and positioning it on the workspace.

More information on creating elements can be found here.

The properties dialog of a diagram element opens automatically when a new diagram is created. The properties dialog of an existing diagram can be opened by double clicking on the element on the workspace, via the "Properties" context menu, or via the "Edit/Properties" main menu if the diagram is selected on the workspace.

General

In the properties dialog of the diagram you can set the title, including a multilingual title, under the "General" tab.

Chart type

Once you have selected the chart type on the left (Columns, Bars, Lines, Pie chart, Areas and Further), you can choose from the different sub-options on the right.

Data

The data source of the diagram and the structure of the diagram components are configured here.

Data

Application

The current application is already selected here.

Filter

Opens a dialog where a filter can be defined. This filter will filter the application data before it is presented in the diagram.

Data group

Select the data group whose values should be shown in the chart.

Insert subordinate data group

Opens a dialog where the subordinate data groups, whose data should be included in the diagram, can be selected here.

Subordinate data groups

In the "Available" column, you can see all selectable sub-data groups. Move the desired data group to the "Selected" list by clicking on "Move to right". "Move up / down" changes the order of the selected sub-data groups.

Click "OK" to save changes and close the dialog again.

Display dependent rows

Show dependent rows This setting affects the way records that exist in a parent-child relationship to the superior, currently selected data record will be shown.

Values

In this area, you will see an image of the previously selected chart.

Values

Here, a field should be selected that contains a meaningful value. The values of this field will be automatically summated. This sum defines, depending on the type of chart, the height of the columns, length of bars, or size of the areas in the chart. Negative values can also be displayed, in that the individual rows will then be shown in the bar chart below the row axis.

Rows

In this drop-down list, you will define by which criteria the values will be arranged on the x-axis (horizontal axis). By selecting "[One row]", which can be chosen for all chart types other than the pie chart, the "Values" are summated.

Categories

Here, a field can be selected that should be used to group the data in the chart.

Unit

For categories of the “date” type, a corresponding "Unit" (Second, Minute, Hour, Day, Week, Month, Quarter, and Year) can be selected for display in the diagram.

Sorting

Category

The chart is sorted by categories with this setting.

Row

The chart is sorted by row values with this setting.

Value

The chart is sorted by the values defined in the value range with this setting.

Sort ascending/descending

Specify here whether sorting should be in ascending or descending order.

Special feature: XY chart

In the case of the XY chart, which can be selected under the "Other" diagram type, the description of the values can be edited.

Click on "Change description".

Here you can enter what is being displayed as a description of the individual values in the XY chart.

Static value

Enter a static title here. Click here for information on multilingual titles.

Data field title

If this option is active, the title will be obtained from the selected data field.

From data field

Enables the selection of a data field whose content will be used as a description of the values.

Settings

Max. number of data records

Defines the maximum number of data records to be shown in the chart. If -1 is entered here, all data sets will be displayed.

Number of records displayed initially

Define how many data records should be shown when the chart is loaded. Activate the "Show scrollbar" setting on the "Interaction" tab to gain access to more values in the chart.

Display title

Displays the diagrams legend.

Display text if no data record is found

If this is selected, a text will be displayed when there is no data available.

Use global text

The global text is used that is stored in the Regional settings of the portal properties under Global language constant "DR_NO_RECORD".

Text if no data record is found

A static text or a constant can be entered here if the "Use global text" setting is deactivated.

Enable export

With this setting, a button will be shown next to the chart in the browser that can be used to select an export format. The chart can be exported as a jpg, png, svg or pdf file.

Value axis / Series axis

Label axis

Enter a label for the Value/Series axis here.

Scale labels at an angle of .... Degrees of rotation

The series axis labels will be rotated by the angle entered here.

Interaction

Link when clicking on a data point

Edit

Opens a dialog where a page can be defined, which is opened when a user clicks on a data point.

Show vertical line at the closest mouse data point

To improve orientation, a vertical line at the data point closest to the mouse can be shown.

Show all data information at once

Shows all data points at once in a quicktip on the chart surface.

Enable zoom

This setting allows an area to be selected with the mouse and zoomed in on.

Display scroll bar

Additionally, a scrollbar can be shown, which is shown in the chart's Header, enabling an area of the chart to be reduced in size.

Display graph in scrollbar

Additionally shows the area that is currently restricted.

Enable moving

Can only be selected if "Enable zoom" is not activated.

Expand to maximum available width

Adjusts the width of the element to its surrounding elements.

Colors

No specification

The existing colors will not be edited with this option.

From data field

A data field can be selected that contains a hexadecimal color value. If, for example, all of the bars in the diagram for Employee A should be shown in green, the hexadecimal value for green needs to have been entered for every data record created for this employee.

Fixed specification

The colors listed here will be used one after the other for the row element of the diagram.

"Preview" column

A preview of the color is shown here.

"Hexadecimal" column

Shows the hexadecimal color value.

Add Color/ Edit Color

Opens a dialog where a color can be selected.

Remove color

Removes the currently highlighted color from the list.

Guides

With guides, areas in the diagram can be highlighted in color. Guides can be defined for every diagram type apart from pie chart, funnel and XY charts.

Guide values

"From" / "To" / "Background color" column

Specify the area, which should be colored, in the first two columns. The color can be selected in the third column.

Create guide

Adds a new row to the list. The values can be edited directly by clicking on the corresponding cell.

Delete guide

Removes the selected guide from the list.

Guide categories

Dynamic

This option available if a data field with the type Date is selected for the Categories on the "Data" tab. If the option is selected for the first time, a dialog will open automatically where the guide series can be configured.

Edit guide series

Opens a dialog where the color, series pattern and duration for the guide can be defined.

Guide series

Color

Select color

A color can be selected for the guide, e.g. to highlight the month of June.

Color the complete area

The entire area is colored in.

Series template

Define an internal for the series pattern here.

Series duration

Ends after

After this amount, the highlighting will no longer be shown.

No end date

If an end date is not selected, the highlighting applies to the entire diagram.

Click "OK" to save the changes and close the dialog again.

Static

Here, static areas for the categories can be colored in.

"From" / "To" / "Background color" column

Specify date values for the area, which should be colored, in the first two columns. The color can be selected in the third column.

Create guide

Adds a new row to the list. The values can be edited directly by clicking on the corresponding cell.

Delete guide

Removes the selected guide from the list.

Options

Show XML names

Displays the chart's layout properties in XML.

Show real names

Displays the names of the chart's individual layout properties

Line color, line strength, graphs, help lines, the background image, and much more are defined here. More information on possible adjustments can be found in the API for the third-party solution amCharts.