Column chart
allows you to compare values for a set of unordered items across categories through vertical bars ordered horizontally.
Column chart
need a minimum of one value element and one column element to showcase. The measure column or expression column that you would like to analyze can be dropped into values block. The dimension column that you would like to categorize the measure column can be dropped onto Columns block. If you would like to categorize based on a series column, then the respective dimension column can be dropped onto Rows block in addition. These blocks are composed into Data pane.
NOTE: Before adding the card widget to the design layout, make sure to create the data source. You can refer to this section to learn how to create a new data source.
The following steps explains data configuration of column chart:
Drag and drop the column chart control
icon from the tool box into design panel. You can find the control in tool box by search.
Resize the widget as required.
Click the Properties icon
in the configuration panel.
The properties
panel of the widget will be displayed as shown in the following screenshot. Now, switch to the ASSIGN DATA
tab.
The data tab will be opened with the available columns from the connected data source.
Bind column by dragging and dropping the element from sections to values
.
IMPORTANT:
Drag and drop the elements from sections to columns.
IMPORTANT:
On Adding the second value to the Columns section, the alert message will be shown.
Click Yes
to enable the option. If you click No
, single value will be added to the Columns section.
Figure: Chart with drilled view of the selected region.
Drag and drop the elements from sections to Row
.
You can configure tooltip section
to showcase the additional information in the widget’s tooltip without affecting the visualization. Refer to this section for more details on configuring the tooltip fields.
You can filter
, format
, and sort
the data displayed in the widget from the settings menu options. To open the settings menu
, click the settings icon
.
The following screenshots shows the various settings menu options based on the type of field configured in the type of section.
You can change the aggregation type of the measure section from the settings menu as shown in the following screenshot. Refer to this section for more details.
You can use Filters to change the values by selecting the Filter
option. For more details, refer to Measure filter and dimension filter.
You can format the elements by selecting the Format
option. For more details, refer to measure format.
You can Sort
the dimension data using Sort
option under Settings menu list. To apply sorting for the data, refer Sort.
The configured field names can be edited by using the Rename
option provided in the settings menu.
Click the Settings menu icon and select the Rename
menu option.
The column name will become editable now. Enter the required text and press enter
key.
Now, the changes will be reflected in the column chart widget’s tooltip, chart legends, and in the axis titles.
You can format the column chart for better illustration of the view that you require using the settings available in Properties
tab.
This allows you to set title
for this column chart widget.
This allows you to set subtitle
for this column chart widget. It is optional.
This allows you to set brief explanation about this grid widget. It is optional.
Click the Change
button to open the Chart Type and Axis Settings
dialog.
Chart Type: This allows you to switch the widget view from current chart type to another convertible chart type.
Secondary Axis: By default, the configured field is plotted as the primary axis, if you enable this option, the selected field will be plotted as the secondary axis.
This allows you to enable the rendering of series in animated mode.
A Legend is a text used to describe the data plotted. This allows you to toggle the visibility of legend in chart and also change the legend text position (selecting through combo box).
Enabling this option of Custom Legend Text will allow you to define a custom text (through the text area) to display for each legend series (selecting through the combo box) in chart.
This allows you to change the chart legend title and label colors.
You can customize the legend text through the Custom Legend Settings
dialog. This dialog will show the legend text list as labels at left and corresponding text area at right to add the formatted text to display instead. When a column is added to Row section, this dialog will show two options Individual
and Group
at top in addition, to toggle between.
Selecting Individual
option will allow you to define a custom text (through the text area) to display for each legend series in chart with the default format:
{{ : Row }} ({{ : Y Value }})
Where, Row represents the value of dimension column added to Rows section
and Value represents the value of the measure column added to Values section
.
Enabling Group
option will allow you to set the display format and define a custom text (through the text area) to display for each legend series based on the specified format.
For example, If Display Format is {{ : Row }} ({{ : Value }})
, then Legend series will display like Austria (Sum of Freight)
This provides option to select the legend placement.
Enabling Show Legend
option will allows you to toggle the visibility of Legend Title.
legend title
property allows you to edit the legend title for chart.
This allows you to toggle the visibility of value labels.
This allows you to customize value label’s color.
This allows you to define the rotation angle for the value labels
to display.
Allows you to enable the Suffix value text to the value labels.
This allows you to show data, which column does not have value.
To configure the linking to URL or dashboard with the widget using its settings. For more details, refer to Linking.
This section allows you to customize the axis settings in chart.
This allows you to customize the axis title color.
This allows you to customize the axis label color.
This allows you to toggle the visibility of category axis.
This allows you to toggle the visibility of category axis title.
This allows you to edit the category axis title for chart. It will reflect in x-axis name of chart.
This allows you to handle the display mode of the overlapping labels in the category axis.
This option trims the end of overlapping label in the axis.
This option hides the overlapping label in the axis.
This option allows you to trim axis labels, based on the ‘Maximum Label Width’ property value.
This option allows you to set maximum width for the axis labels, and also it can be made customizable when the trim axis label option is enabled.
This allows you to define the rotation angle for the category axis labels to display.
This allows you to enable the primary value axis for chart.
This allows you to enable the visibility of primary value axis title of chart.
This allows you to edit the primary value axis title. It will reflect in y-axis name of chart.
This option allows you to format primary and secondary axis values from the formatting details provided using ‘Format’ button. For more details, refer to thismeasure format.
This allows you to customize Axis type as linear
or logarithmic
Linear: Linear interpolation is used to determine where a value lies on the axis.
Logarithmic: Logarithmic axis uses logarithmic scale and it is very useful in visualizing when the data has values with both lower order of magnitude (eg: 10-6) and higher order of magnitude (eg: 106).
This allows you to manually set the Minimum, Maximum, and Interval values of primary value axis through the Axis Range Settings dialog.
It will reflect in the primary value axis of the chart.
You can toggle the visibility of the each axes gridlines visibility using the property and refer to this page for more details.
You can add, edit, and delete the trendlines for the chart widget using the Trendline properties
. Refer to this page for the detailed steps.
This allows you to customize the chart series color through Series Palette
section.
IMPORTANT: Series color palette option will be enabled only when the row field is configured.
This allows you to toggle the series color between default palette and custom palette. By default, the property is toggled on and default palette will be applied to series.
By toggle off the Use Default Palette
, you can customize the series colors. This section shows the list of series labels on the left-hand side and corresponding series color on the right-hand side. By clicking the colored square, color picker will be opened. You can choose a color. And, you can also change the series color by changing the corresponding Hexadecimal value in the right-hand side.
IMPORTANT:
Formatting section
will be enabled when the widget is configured, and it will be hidden if the row field is configured.
In the Formatting section
, there will be options to define the color for the each of the configured value fields.
You can select the color by clicking the color picker option provided near the field name. it will open the color picker.
Advance setting
option will be enabled when only one column and one row is configured. You can refer more details from this section
This allows you to define this column chart widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.
This allows you to define this column chart widget to ignore responding to the filter actions applied on other widgets in dashboard.
Using this option, you can enable or disable hierarchical top N filtering. While applying Top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering need to be done as flat or based on the hierarchy of dimension columns added.
When Hierarchical Filter option
is enabled, the Top N will be applied for each individual column separately based on the number set for each column.
This allows you to customize the widget container appearance, widget title’s properties and provides options to enable or disable the widget exporting options. For more detailed information, refer to the container appearance properties.
Title Alignment
This allows you to handle the alignment of widget title to the left, center or right.
Title Color
This allows you to apply text color to the widget title.
Show Border
This allows you to toggle the visibility of the border surrounding the widget.
Corner Radius
This allows you to apply the specified radius to the widget corners if the Show Border is enabled. Value can be between 0 and 10.
Background Color
This allows you to select the color for the chart background. The default value is #ffffff
.
Show Header
This allows you to enable or disable the widget title of the column chart widget.
Allow Maximize View
This allows you to enable or disable the maximized mode of the Column chart widget. The visibility of the maximize icon in the widget header will be defined based on the setting in the viewer.
Allow CSV Export
This allows you to enable or disable the CSV export option for the Column chart widget. Enabling this allows you to export the summarized data of the widget view to CSV format in the viewer.
Allow Excel Export
This allows you to enable or disable the Excel export option for the Column chart widget. Enabling this allows you to export the summarized data of the widget view to (.xlsx or .xls) format in the viewer.
Allow Image Export
This allows you to enable or disable the image export option for the Column chart widget. Enabling this allows you to export the view of the widget to image format (.jpg), (.png), or (.bmp) in the viewer.
Allow PDF Export
This allows you to enable or disable the PDF export
option for the Column chart widget. Enabling this allows you to export the view of the widget to pdf format in the viewer.
Enable Comments
This allows you to enable or disable comment for the dashboard widget. For more details refer to here
Allow View Underlying Data
This allows you to visualize the raw data associated with a widget at runtime.
To learn more about viewing the underlying widget data, refer to the view data documentation.
Color in column chart widget can be customized using the color settings available in the properties
section. This will allow the users to improve the visualization in column chart and to distinguish the data based on conditional range values that will let the visualizer to understand what is shown in data.
In the properties
pane, under the Formatting
section, check the Advanced Setting
check box.
This will open the Conditional Formatting
dialog.
Select the mode and enter the conditions as required and click the save
button to apply.
Now, the widget visualization will be updated based on the conditions.
Refer to the following sections for the detailed steps on using the Gradient, Rule and individual modes.
You can customize the fill color of the column chart using the gradient based conditional formatting. This is the default mode.
You can choose any field from the Based-On section to apply the conditions from the drop-down.
You can select the summary type for the selected measure field.
You can define your range by entering the low, mid, and high values.
NOTE: It is optional, if no value is entered then the ranges will be auto calculated based on the minimum and maximum values from the data source.
You can enter the title for the column chart legends.
This allows you to customize the fill color of the column chart based on one or more numerical / text conditions.
The value type drop-down allows you to choose whether you are going to apply the direct value (specific number like 3 goals, order ID 10248) or percentage (values above 30% or 50 %).
You can give a meaningful name to the applied conditions.
Choose the condition for measure field from the highlighted conditions.
If you selected the dimension as a based-on field
and want to use text condition, the following text-based conditions are available.
The text-based condition type will be enabled only when the dimension selected is used as the based-on field.
You can mention the condition value.
For the dimensions, case sensitive option is provided to choose whether the entered value is case sensitive or not.
Select the fill color for that condition using the color picker.
Click add condition
to specify add new condition.
Click the delete
button to remove the existing condition.
Using the individual
mode, you can specify color for each record.
IMPORTANT: Only top 100 records will be listed in the dialog.
You can choose the color for the record from the nearby color picker.
To undo all the changes, click reset
.