Use the Column Chart control to compare counts or amounts across categories, such as the number of projects per owner or opportunity budgets by stage. The control offers vertical columns and horizontal bars.
Use one bar per category for a single metric. Use clustered series to compare groups side by side and stack segments when the values can be added meaningfully.
Add Column Chart to the page
In the page designer, open Data Analytics in the controls panel. Drag Column Chart into a section or container. Dashboard example
Select data source
Choose the source for the chart. For example, select the Projects list to count projects by owner. Choose a form report when it is available in the source selector and contains the fields you need.
Open the Content > Data Source block, and in the Application section, select the application which is the current application by default.
Afterward, move on to the List section. Select the data list under the selected application.
In Data Filters, select Setting to choose which records to include, such as projects in the reporting period.
Chart type, X and Y axis
Open the Content > Chart block to select the chart type and the fields as X-axis and Y-axis of this Column Chart.
Chart Type: select the chart type as Clustered column, Stacked column, Clustered bar, or Stacked bar.
Clustered column or bar. Show the series side by side to compare their values within each category.
Stacked column or bar. Show the parts of each category’s total. Choose series with the same unit that can be added together.
X-axis (Category). Choose the main grouping. In a horizontal bar chart the category labels appear along the vertical edge, while the setting is still named X-axis (Category).
For a project count, choose Owner from the Projects list. For an opportunity comparison, choose Stage.
X-axis (Subcategory). Use an optional second field to split each category into series. For example, compare opportunity counts by Stage and Source. When a subcategory is selected, Y-axis (Second Value) is unavailable.
Y-axis (Value). Choose the measure displayed by the height of each column or the length of each horizontal bar.
Choose the field and calculation. Use Id with Count for project counts, or a numeric field with Sum for an amount. Depending on the field, choices can also include Count distinct, Avg, Max, and Min.
Y-axis (Second Value). To compare two measures across the same categories, leave Subcategory empty and select a second value. The subcategory is unavailable while the second value is set. Click Submit, then compare two categories with the filtered source records.
Settings of Column Chart
Chart Height: Set the height of this Column Chart control.
Axis Line: Show/hide the line of Axis on the Column Chart.
Grid: Show/hide the grid line on the Column Chart.
Axis Labels: Show/hide the labels of X-axis and Y-axis.
Title of Column Chart
Display: turn on to show title of the Column Chart.
Chart Title: type the text of the title, or set dynamic content as the title text.
Title Position: set the display position of the title as Before Chart or After Chart.
Text Align: Set the alignment of the title as Left, Center, Right, or Justify.
Legend of Column Chart
Display: turn on to show Legend of the Column Chart.
Position: set the display position of the legend around the Column Chart.
Tooltip of Column Chart
Enable: turn on to show Tooltip of the Column Chart.
Number Suffix: set the suffix of the number on the Tooltip.
Styling the Column Chart control
Title
Text Color: Set the color of the title.
Typography: Set the typography of the title.
Margin: Set the Margin of the title in PX , %, em, rem, vw, calc.
Padding: Set the Padding of the title in PX , %, em, rem, vw, calc.
Text Shadow. Set the shadow applied to the text.
Label
Font Family: Set font family of the label.
Size: Set font size of the label.
Weight: Set font weight of the label.
Style: Set font style of the label.
Text Color: Set the color of the label.
Legend
Font Family: Set font family of the legend.
Size: Set font size of the legend.
Weight: Set font weight of the legend.
Style: Set font style of the legend.
Line-Height: Set line-height of the legend.
Text Color: Set the color of the legend.
Tooltip
Background Color: Set the background color of the Tooltip container.
Padding: Set the Padding of the tooltip container in PX , %, em, rem, vw, calc.
Text Shadow. Set the shadow applied to the text.
Title: Set the Title's style of the Tooltip.
Font Family: Set font family of the Tooltip's title.
Size: Set font size of the Tooltip's title.
Weight: Set font weight of the Tooltip's title.
Style: Set font style of the Tooltip's title.
Line-Height: Set line-height of the Tooltip's title.
Text Color: Set the color of the Tooltip's title.
Value: Set the Value's style of the Tooltip.
Font Family: Set font family of the Tooltip's value.
Size: Set font size of the Tooltip's value.
Weight: Set font weight of the Tooltip's value.
Style: Set font style of the Tooltip's value.
Line-Height: Set line-height of the Tooltip's value.
Text Color: Set the color of the Tooltip's value.
Advanced Settings
Set the Advanced options that are applicable to this control.



