a!columnChartConfig( primaryGrouping, secondaryGrouping, measures, sort, dataLimit, link )
Contains configuration for how to display data in a column chart. See the Column Chart Component page for examples on using this configuration supporting function.
See also:
Name | Keyword | Types | Description |
---|---|---|---|
Primary Grouping |
|
Grouping |
Defines the field labels to display on the axis in the chart, configured using |
Secondary Grouping |
|
Grouping |
Defines the field labels to display in the stacking or grouped bars in the chart, configured using |
Measures |
|
Measure |
Defines the numerical calculations for data in the chart, configured using |
Sort |
|
SortInfo |
Use |
Data Limit |
|
Integer |
Maximum number of data points to display on the chart. Default: 100. Valid values: 1-5000. |
Link |
|
Any Type |
Link to execute when a user selects a data point on the chart. Use |
a!columnChartConfig()
is always used within a column chart component.Count of <primary key field name>
.fv!selection
. This variable returns a map that contains each of the field aliases as the key and the unformatted value as the value. Since the alias is used for the key, aliases are required for each grouping and measure when using a link. See Chart Configuration Using Records for an example of how to configure a link.The following patterns include usage of the Column Chart Configuration.
Aggregate Data by Multiple Fields and Display in a Chart (Reports, Charts, Query Data, Records): Aggregate data by multiple fields and display it in a stacked column chart. In this pattern, we will calculate the total number of employees for each title in each department and display it in a stacked column chart.
Configure a Chart Drilldown to a Grid (Charts, Grids, Query Data, Records): Displays a column chart with aggregate data from a record type and conditionally shows a grid with filtered records when a user selects a column on the chart.
Total Orders Compared to Orders Purchased with Promo Codes (Records, Reports, Charts): This pattern illustrates how to create a column chart that compares the number of total orders and the number of orders that had at least one item purchased with a promo code.