Advanced bar 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 Bar Chart displays data as a series of rectangular bars with heights or lengths proportional to the represented values, which can also be shown in 3D. It is possible to create more complex charts than with Basic Bar Charts. For example, the Category Property is not limited to some data types and more visual properties are available.

Usage

Advanced Bar Charts are used to compare values.

Examples

Advanced Bar 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.
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.
Enable 3D	Enable to display the chart in 3D by defining values for alpha, beta, depth and column depth.
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.
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.
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.
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.