Curation - Column Chart | AO Platform

Intended audience: end-users analysts developers administrators

AO Platform: 4.4

Overview

This topic contains an overview of a Column Chart. A Column Chart allows quick interpretation of trends, patterns, or comparisons, aiding decision-making in the curation process.

Example

Configuration of Column Chart

DATA Properties

Label	UI Widget	Default	Description
DATA
X-axis Field	Dropdown w/Expression option		The X-axis Field allows the user to select the MSO Field Property to represent the X-axis values in the Chart.
Show Series Data in Row	ON/OFF Toggle	OFF	If enabled, select a single Series Type and Series Field below. If disabled, select one or more Series Fields below.
Series Fields	Repeater Dropdown w/Additional Properties, Expression, and Color options		The Series Fields allow the user to select an MSO Field Property to represent the Series Field.
… Active	ON/OFF Toggle		If enabled, the feature or data series is active and will be applied or shown in the column chart.
… Use Series Field to Apply Data Styles	ON/OFF Toggle		The ON/OFF toggle refers to enabling or disabling the application of data styles to the series field.
… Series Name	Text Field		The Series Name allows the user to enter Series Names that will be used to identify the data Series in the Legend
… Y-Axis Name	Text Field		The Y-Axis Name field displays the name of Y-Axis.
… Exclude Zero Values	ON/OFF Toggle		If enabled, zero values will be excluded. By default, this setting is disabled.
… Additional Properties	Key / Value - Text Fields		Optional Additional Properties - expressed as a Key/Value pair.
Series Type Field	Dropdown w/Expression option		The Series Type Field dropdown in area chart curation allows the user to specify a field that determines the type of series displayed in the chart.
Series Field	Dropdown w/Additional Properties and Expression options		The Series Fields allow the user to select an MSO Field Property to represent the Series Field.
… Use Series Field to Apply Data Styles	ON/OFF Toggle		The Use Series Field to Apply Data Styles ON/OFF Toggle controls whether data styles are applied based on the series field: ON: Data styles will be applied dynamically according to the series field. OFF: Data styles will not be influenced by the series field.
… Series Names	Name / Display Name - Text Fields		The Series Name allows the user to enter Series Names that will be used to identify the data Series in Legend.
… Additional Properties	Key / Value - Text Fields		Optional Additional Properties - expressed as a Key/Value pair.
Colors	Text Field w/Color Palette option		The Colors allows the user to select which color to use for the columns of the chart. See Curation - Field Properties - Data Styles.
Max no. of records	Number Field		Option to set a Max number of records to be used by the Chart.
Sort By Field	Dropdown w/Expression option		The Sort By Field option allows the user to select a field to sort the data and also provides the flexibility to define a custom expression for more advanced sorting criteria.
Sort Direction	Dropdown		Option to set the Sort order for data in the Chart to either Ascending or Descending.
Base Series	Dropdown		The dropdown Base Series field allows the user to select an option relating to each series Field, such as Bell Curve, Histogram, Pareto.
Apply when shown from a Connected MSO	ON/OFF Toggle	OFF	The Apply When Shown from a Connected MSO ON/OFF Toggle determines whether the settings or actions are applied specifically when data is displayed through a connected MSO. ON: The feature or behavior is applied when the data originates from the connected MSO. OFF: The feature or behavior is not applied, regardless of the connected MSO.
Apply Curation Data Size for the App Data	ON/OFF Toggle	OFF	If enabled, the Record Count rules will be applied. If the Record Count rules are not met, the series will not be shown.
Show TopN plus Other	ON/OFF Toggle	OFF	If Show TopN plus Other enabled, the App will display only the Top N records along with a single aggregated category representing all other records. The number of records shown for the Top N is determined by an MSO Setting in the Easy Answers section. If disabled, the App will display all records based on the user's query.
Show all Data on Data tab and in Data Download	ON/OFF Toggle	OFF	If enabled, all records, otherwise excluded by the LIMIT clause when “Show TopN Plus Other” is enabled, and used by the App, will be shown on the App’s Data tab as well as in the Download Data option.
Additional Tooltip Data Properties	Display Name - Text Field MSO Property - Dropdown		The Additional Tooltip Data Properties allow the user to select one or more MSO Field Properties to display their values in the tooltip when the user hovers over a data point.

AXIS Properties

Label	UI Widget	Default	Description
X-Axis Type	Dropdown		Option to select the format of the X-Axis, including Linear, Logarithmic, DateTime, Category, Color, and BellCurve.
Show Data as Stacked	ON/OFF Toggle	OFF	If enabled, data for multiple series will be displayed as stacked for each X-Axis value. If disabled, the data will be shown as grouped.
Add Reference Links in X-Axis Label	ON/OFF Toggle	OFF	If enabled, X-Axis labels will be converted into clickable links, with their content defined by the JavaScript in the Link JS Function. When disabled, the labels will not include links.
Link JS Functions			The Link JS function allows the user to select from an existing JavaScript Function to be used to generate links for the X-Axis Labels
Show Axis Titles	ON/OFF Toggle	OFF	If enabled, titles can be added to both the X-Axis and Y-Axis. If disabled, the X-Axis and Y-Axis will not have titles.
X-Axis Title	Text Field
Y-Axis Title	Text Field

DATA LABELS Properties

Label	UI Widget	Default	Description
None/Percentage/Value	Dropdown w/Additional Properties option	Show Percentage	Optional Additional Properties - expressed as a Key/Value pair.
… Additional Properties			Optional Additional Properties - expressed as a Key/Value pair.
Data Label JS Function	Text Field w/Search		The Data Label JS function allows the user to search for and define JavaScript functions that control the display or behavior of data labels in a chart.
Lazy Load Data Labels	ON/OFF Toggle	OFF	If enabled, in the Column chart, curation controls whether data labels are loaded gradually as the chart is interacted.

Label	UI Widget	Default	Description
Show X-Axis Name in Tooltip	ON/OFF Toggle	OFF	If enabled, the tooltip displayed when hovering over data in the App will include the X-Axis name. If disabled, only the data value will be shown, without the X-Axis name
Additional Tooltip Properties	Key / Value - Text Fields		Optional Additional Tooltip Properties - expressed as a Key/Value pair.

ZONE Properties

Label	UI Widget	Description
Zone Axis	Dropdown	The Zone Axis dropdown allows the user to select different zones within the chart, often used for visual emphasis or categorization.
Zone Axis Properties	Dropdown w/Additional Properties and Expression options	The Zone Axis Properties dropdown allows the user to customize the properties of the Zone Axis in a Column Chart.
… Zone Color	Text Field	The Zone color refers to the color applied to different zones within a chart or graph.
… Additional Properties	Key / Value - Text Fields	Optional Additional Tooltip Properties - expressed as a Key/Value pair.

STYLES Properties

Label	UI Widget	Default	Description
Show in 3D	ON/OFF Toggle	OFF	If enabled, it shows the Column Chart with some depth and at a rotated angle.
Disable Animation	ON/OFF Toggle	OFF	The Disable Animation toggle refers to turning off any animated transitions or effects that occur when the chart or visualization is rendered or updated.

Contact App Orchid | Disclaimer