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.
Example:
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.