Column chart with stacking of multiple groupings.
|Stacked Column Specific Options:|
|Plot Data/Y-axis||Numeric Y-axis field to use. Leave it empty if for multiple Y-axis fields.|
|Grouping/Legend||Different groupings of data|
|X-Axis||X-axis field, if applicable.|
|X-Axis Ordering||Optional X-axis data ordering, if applicable|
|X-Axis Type||Set to Date/Time for a time series chart.|
|Legend Ordering||Legend ordering method, if applicable|
|Y-Axis Max||Optional max Y-axis value. Use this in conjunction with tick interval to adjust Y-axis scale & labeling.|
|Y-Axis Tick Interval||Optional Y-axis tick interval to set the Y-axis labels.|
|Target Line||Optional value for target line, only apply to primary Y-axis.|
|Stacking - Second X-Axis Group||Displays a second stacking group on the X-axis based on the string field selected. Optional|
|Secondary Y-Axis||Optional Secondary Y-axis on the right hand side of the chart.|
|Secondary Chart Type||Chart type for the secondary chart|
|Secondary Chart Send to Back||When this property is checked, it adjusts the z-index to send the secondary chart behind first|
|Synchronize Y-Axis||When this property is checked, it synchronizes the Y-axis primary and secondary to the same values|
|X-Axis Sub Groups||
Define X-axis sub groups. It will allow you to create multiple X-axis sub groups, applicable only for non-date type x-axis fields.
X-Axis Sub Groups
The sub group allows you to add one or more column levels or column sub-grouping by X axis. The chart outputs the values in columns. The sub-group can have multiple levels of hierarchy of the parent column group on the X-Axis. Enabling this functionality segregates the parent group into its children (sub groups) with respect to the legends.
In the column visualization below, you can observe how the parent group - “Continent” is divided into “Country”, and how the “Country” is subdivided into “City” with all of them sub-grouped together.
Note 1:If you select "Date/Time" from the X-Axis Type then the "X-Axis Sub Groups" field will not be visible in the interface.
Note 2: You can also perform the sub-groups functionality in the Column and Bar visualization.