Advanced line/area chart

Important

All solutions have access to try advanced charts, but use of an advanced chart in Production is determined by your subscription tier.

The Advanced Line/Area Chart displays a series of data points connected with a straight line, which can also be shown as area or radar chart. It is possible to create more complex charts than with Basic Line Charts. For example, the Category Property is not limited to some data types and more visual properties are available.

Usage

Advanced Line/Area Charts are used to show changes or trends over a certain time, or to compare multiple datasets.

Examples

Advanced Line Charts examples are available in our Showroom. You can view the demo, as well as access the setup in Appfarm Create. Don't have access? Register.

Properties

Property	Description
Data Source	Select a data source to display as a chart.
Filter	Apply a filter to the selected data source.
Conditional Filters	Create conditional filters to apply to the selected data source.
Category Property	Select a data source to display as X Axis in the chart.
Hide Empty	Visible when Category Property is selected. Enable to hide categories without content.
Group By	Visible when Category Property of data type Datetime is selected. Select a dimension to group the data by. If no dimension is selected, all objects will be displayed in the order given by the data source.
Custom Format	Visible when Category Property of data type Datetime and a Group By dimension is selected. Define a custom format to override the format of the data source. Check momentjs for a complete reference.
Value Property	Select a data source to aggregate the data on. If no data source is selected, count will be used by default.
Aggregation Function	Visible when Value Property is selected. Select one of the functions Count, Sum, Average, Median, Minimum or Maximum to aggregate the data on.
Show Uncategorized	Visible when Value Property is selected. Enable to show uncategorized data as a separate category.
Area Range	Visible when Aggregation Function Median or Average is selected. Enable to add an area range for the aggregated value.
Default Name	Enter a default name for one dataset. If no dataset property is selected, only one dataset will be shown.
Dataset Property	Disabled if a Default Name is entered. Select a data source to split the data into datasets based on this property. If no data source is selected, all the data will be treated as a single dataset.
Color Value	Visible when Dataset Property of data type Boolean or Integer is selected. Set the dataset color from a data source of type Enum Type.
Use Enum Colors	Visible when Dataset Property of type Enumerated Type is selected. Enable to use the colors defined in each Enum Value.
Limit Datasets	Visible when Dataset Property of type Enumerated Type is selected. Enable to limit the dataset property by one or more Enum Values.
Stack Datasets	Visible when Dataset Property is selected. Define to stack datasets Normal or to 100%. By default, None is selected.
Use Static Datasets	Only visible when Dataset Property is not defined. Enable to use static datasets instead of defining a dataset property.
Dataset Name	Visible when Use Static Datasets is enabled. Enter a static name for the dataset or bind it to a data source or function.
Filter	Visible when Use Static Datasets is enabled. Apply a filter to the selected data source.
Value Override	Visible when Use Static Datasets is enabled. Override the value if the value used for the dataset is stored in another property than the main value property.
Color	Visible when Use Static Datasets is enabled. Define a color for the dataset.
Disable Gradient	Enable to lighten up the color value.
Area Chart	Enable to transform the chart into an area chart.
Opacity	Visible when Area Chart is enabled. Define the opacity of the area color.
Show Points	Enable to visualize points as long as the distance between them are large enough. Otherwise, points will never be displayed.
Disable Bezier	Enable to display straight lines instead of rounded lines between each point. May be used to increase performance.
Show Steps	Visible when Disable Bezier is enabled. Enable to draw steps between the points, instead of straight lines.
Step Align	Visible when Show Steps is enabled. Define whether the steps should be aligned horizontally on the left, center or right.
Title	Enter a static title or bind it to a data source, function, date now or date today.
Sub Title	Enter a static title or bind it to a data source, function, date now or date today.
Show Legend	Enable to show a legend.
Legend Position	Visible when Show Legend is enabled. Position the legend on the top, left, bottom or right side of the chart.
Disable Animation	Enable to stop animation of the chart.
Sort By Data	Enable this to sort the Categories by Ascending Value (lowest to highest). If you want to reverse this sorting, use the Reverse option on the X-Axis.
Zoom Type	Define if the X Axis, Y Axis or both should be zoomable. By default, None is selected.
Show Data Labels	Enable to show data labels above each data point.
Disable Mouse Tracking	Enable to block the chart for mouse tracking activities.
Tooltip Value Decimals	Define decimals to override the number of decimals shown for the y value in the tooltip.
Polar	Enable to transform the chart into the polar coordinate system. The chart is then displayed as a polar/radar chart.
Invert Axes	Enable to invert both X Axis and Y Axis with each other.
Enable Navigator	Visible if Category Property is selected. Enable a navigator on the X Axis.
Minimum Range	Visible if Navigator is enabled. Define the minimum window when zooming in. By default, one week is selected.
Maximum Range	Visible if Navigator is enabled. Define the maximum window when zooming out. By default, all data is selected.
Axis Title	Enter a static title or bind it to a data source, function, date now or date today.
Axis Type	Select a type for the axis: Auto, Linear, Logarithmic, Datetime or Category.
Tick Interval	Set an interval for ticks on the axis. If the interval is too dense to be displayed, some ticks will be removed automatically. Note that axes with data type Datetime are based on milliseconds.
Tick Mark Placement	Only applicable for Category Axis (X Axis). Define the position of the tick marks on the X Axis. If Auto is selected and the interval is 1, the tick mark is placed between categories, else the tick mark is placed in the center of the category. If Between is selected, the tick mark is always placed between categories. If On is selected, the tick mark is always placed in the center of the category.
Min Value	Define the minimum value on the axis. If no value is set, it will automatically adjust to data.
Max Value	Define the maximum value on the axis. If no value is set, it will automatically adjust to data.
Enable Grid Lines	Enable to show grid lines on the axis.
Enable Crosshair	Enable a crosshair on the axis.
Hide Axis	Enable to hide the axis.
Reverse Axis	Enable to reverse the axis in order to display the values from highest to lowest.
Place Opposite	Enable to place the axis on the opposite side of the chart.
Synchronize Axis	Only applicable for Category Axis (X Axis). If selected, hover values and zoom will be synchronized across charts. To synchronize this axis with other charts, first a Topic in the current App (found under App Settings) must be created. Any chart connected to the same topic will be synchronized. Synchronization uses chart width to calculate position for the indicators, not axis values. Therefore it must be ensured, that all charts use the same width and showing the same range of data.
Plot Threshold Indicators	Add plot threshold indicators by defining a name, visibility, type (line or band), start value and color.
Event Handlers	You may add an On Series Click action to be executed when the data series is clicked.