This data visualization is commonly used to show and compare different categories of two groups. As this suggests the view used to create this widget type must include 2 groups. It will allow you to clearly isolate trends of each of these categories over time.
Usage Example
You can use it to show all the current opportunities by owner and by adding a second group by Sales Stage, you will be able to see how each of the sales representatives is doing with their own pipeline.
Grouped Column Chart Configuration |
|
View |
Select the view you want to use as the base for your widget. |
Widget |
Grouped Column Chart |
Field |
Defaults to Count. If a field is selected then, a new field called calculation will appear, you can choose between sum, average, max, and min. |
Title |
Optional. The title will be placed at the top of the widget. |
Labels |
|
Horizontal Axis Title |
Optionally add a title to the horizontal axis. |
Vertical Axis Title |
Optionally add a title to the vertical axis. |
Show Labels |
When enabled it will show the name of data in the Vertical Axis. |
Label Display |
Auto. Fits in the labels automatically. Wrap. Adjusts the text in two or more lines when there is not enough space to display them in a single one. Stagger. Interleaves the values one up and one down for a better fit in a single line. Rotate. 90º rotation of the labels. |
Show Legend |
When enabled includes the color code with values of the field used to group the data. It is displayed at the bottom of the widget. |
Attributes |
|
Show Values |
When enabled it shows the count inside each section of the widget, and not just on hover over. |
Place Values Inside |
When enabled, all values are placed inside the columns. Requires Show Value. |
Rotate Values |
90º rotation of the column values. Requires Show Values. |
Format |
|
Default Format |
When disabled, overrides the default format. |
Number Prefix |
Add a prefix to the numbers in the widget, from letters to symbols. |
Format Large Values |
When enabled, large values are condensed. For example, the value $25,000,000 will be formatted as $25M |
Targets Specify target values for your widget. You can add multiple targets. Each target needs: |
|
Target Value |
Assign the target value that will be identifiable in the chart as a line. |
Line Color |
Use the color picker to assign a color to the line. |
Label |
Optional. If empty it will show the target value. |