This data visualization is the perfect combination of a line chart and bar chart when you need to show one or more groups of values during a period of time or any given attribute.
Usage Example
You can use it to create a chart that will show a comparison between the sales of last year vs. the current year or your pipeline by opportunity type.
Configuration
1. View
Select the view you want to use as the base for your widget. You can use a saved view or select "Embedded View" and create a new one for this widget.
2. App
Choose the application you would like to use for the data for the widget.
3. Filter
You can adjust the filters from a previously saved view or add filters just for this widget.
For more information on filters see the following article:
4. Field
Choose the field you would like to use to base your number widget off of. Only fields within your chosen application will be available.
5. Labels
Horizontal Axis Title: add a title to the horizontal axis.
Vertical Axis Title: 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.
6. Attributes
Show Values: When enabled it shows the total of days inside each section of the widget, and not just on hover over.
Rotate Values: 90º rotation of the column values. Requires Show Values.
Stack 100%: When enabled it transforms the horizontal axis values to percentages and presents the values in the corresponding proportions of 100%
Cumulative:If you enable this option, the values of each consecutive attribute will increase by successive additions.
7. Format
Show Top N: If you enter in the number 5 the chart will display the top 5 records based on the filters you chose earlier.
Default Format: When disabled, override the default format.
Number Prefix: Add a prefix to the numbers in the widget, from letters to symbols.
Format Large Values: When enabled, it will apply the required format to simplify the quantities, for example, it will transform 14,000,000 to 14M
8. Targets
These are useful if you have goals or targets you would like to compare your numbers to in your chart.
You can also label and choose a color for your targets to make it more clear what the line represents.