Combo Chart
Last updated
Last updated
The Combo Chart in the KPI tool provides a powerful way to visualize data by combining multiple chart types, including bars, lines, areas, and markers. This highly customizable chart enables users to highlight different aspects of their data in a single view, making comparisons and trends more intuitive. Below is a detailed guide to its features and settings.
Here's a quick guide to create Combo chart in KPI:
In the Data Tab for the Combo Chart, you simply select the field that defines the categories for your data:
Category: Choose the categorical field that will determine the axis or groupings for the chart.
This streamlined configuration ensures that your data is properly categorized and ready for visualization in the Combo Chart format.
Click on 'Add Chart' to begin creating your combo chart. You can combine multiple chart types into one visual to compare different sets of data. The available chart types are:
Chart Type
Choose the chart types you want to combine:
Column Chart: Displays data in vertical bars, ideal for comparing different categories.
Line Chart: Represents data points connected by straight lines, perfect for showing trends over time.
Area Chart: Similar to a line chart, but the area below the line is filled in, showing volume.
Marker Chart: A simple chart where each data point is represented by a marker, ideal for highlighting individual values.
Value - Select Value to Display
This option allows you to choose which data points or measures will be displayed on the chart. You can select multiple values to compare them visually on the same chart.
Color with Conditional Formatting
Conditional formatting lets you apply color rules to your data for better visual emphasis and clarity. You can choose from two types of rules:
Single Rule Conditional Formatting: Apply a single color based on a specific rule (e.g., values greater than a set threshold will be displayed in one color, and others in another).
Compare Rule Conditional Formatting: This rule compares two or more values and applies different colors based on the results of that comparison (e.g., highlighting values that exceed the average in a particular color).
Bar Pattern
Solid: The bars will be filled with a uniform, solid color, making them visually bold and easy to compare.
Dashed: A dashed line pattern fill will be applied to the bars, which can add a stylistic touch or help distinguish between different data sets.
Outline: Only the outline of the bars will be shown, with no fill, emphasizing the structure and relative lengths of the bars.
Bar Border Toggle
Border Width: This setting allows you to adjust the thickness of the border around the bars. Thicker borders help emphasize the bars and can be useful when the chart has many bars with different colors.
Border Color: Choose a color for the border of the bars to create contrast or a visual hierarchy between different data sets.
Bar Corner Radius Toggle
Top Radius: Adjust the rounding of the top corners of the bars. This creates a softer, more modern look for the bars.
Bottom Radius: Adjust the rounding of the bottom corners of the bars. This option helps achieve a uniform rounded appearance if desired.
Show Data Labels Checkbox: Enable this option to display the actual values on top of each bar. Data labels make it easier for users to interpret exact values directly from the chart without needing to reference the axis.
Line Type
Linear: The line connecting data points will be a straight line, offering a simple and clear visualization of trends.
Spline: A smooth, curved line will be used, providing a more fluid and natural look to the data flow.
Step: The line will create a step effect, where the line stays at the previous value until the next data point is reached, then jumps to the next value.
Step After: The step effect occurs after the data point, where the line remains at the previous value until the current point is reached.
Step Before: Similar to Step After, but the line will change to the new value before reaching the data point.
Line Width: Adjust the thickness of the line to make it more prominent or subtle depending on the chart's overall visual style.
Enable Marker Toggle
Marker Type
Circle: A simple circular marker to represent data points.
Square: Square-shaped markers are ideal for data that you want to emphasize with sharp corners.
Diamond: A diamond-shaped marker adds a more dynamic look, great for unique visual distinction.
Upward Triangle: A triangle pointing upwards, often used to represent positive changes or increases.
Downward Triangle: A triangle pointing downwards, typically used for negative changes or decreases.
Marker Size: Control the size of the markers to make them more visible or smaller to minimize visual clutter.
Show Data Labels Checkbox: Enable this option to display the value of each data point next to its marker, which provides precise information about the chart.
Line Type
Linear: A straight line connecting data points, showing clear trends.
Spline: A smooth curve connecting data points, adding an elegant touch to the visual.
Step: A stepped line, perfect for showing sudden changes in values.
Step After: The line steps after the data point, showing trends with a delay.
Step Before: The line steps before the data point, showing trends ahead of the value.
Line Width: Adjust the width of the line to control its prominence and visual impact.
Enable Marker Toggle
Marker Type: Same as the line chart, select from Circle, Square, Diamond, Upward Triangle, or Downward Triangle.
Marker Size: Set the size of the markers to balance visibility and aesthetics.
Area Opacity: This controls the transparency of the filled area beneath the line. Lower opacity makes the chart background visible, while higher opacity makes the area more solid.
Show Data Labels Checkbox: Display the exact values at each data point within the area chart, enhancing readability.
Marker Type
Circle: Use circular markers to represent data points.
Square: Square markers give a clean, modern look.
Diamond: Add a touch of style with diamond-shaped markers.
Upward Triangle: Ideal for showing positive growth or upward trends.
Downward Triangle: Perfect for negative trends or declines.
Marker Size: Adjust the size of the markers to emphasize certain data points.
Show Data Labels Checkbox: This option displays the value of each individual marker on the chart, allowing users to quickly read the data.
Click on the 'Enable' toggle to activate the variance chart. The variance chart allows you to visualize the differences between two sets of data, making it easier to track changes, trends, and comparisons.
Variance Type
Choose the format in which the variance will be displayed:
Column: Display the variance in vertical columns, which is ideal for a straightforward comparison of the data differences.
Area: The variance is shown as a filled area between two datasets, which helps highlight the differences over a range, making trends more visually pronounced.
Variance From
This option defines the starting point or baseline for calculating variance. Select the data or measure you want to compare against. For example, this could be the previous year's data, a forecast, or a baseline value.
Variance To
This option defines the second dataset or target to compare against. It could be the actual value, the current period's data, or any target value that you're measuring performance against. The variance is calculated by comparing the "Variance From" value to the "Variance To" value.
Positive Color with Conditional Formatting
This feature allows you to apply color formatting based on positive variance values. You can choose a specific color to visually highlight positive variance, making it easy to distinguish areas of improvement or positive performance.
Conditional Formatting: Choose the color you want for positive variance values. For instance, you can use green to indicate positive changes or growth.
Negative Color with Conditional Formatting
Similar to positive color formatting, this setting allows you to apply a specific color for negative variance values. This helps to easily identify areas of decline or performance gaps.
Conditional Formatting: Choose the color for negative variance values, such as red, to indicate a drop or negative trend.
Bar Width (Applicable for Column Type Variance)
This setting allows you to adjust the width of the bars in the column chart when displaying variance. A wider bar gives more prominence to the data, while a narrower bar creates a cleaner, less cluttered visual.
Bar Width: Adjust the bar width to fit your visual preferences and chart layout. This setting is only applicable when the Column variance type is selected.
Click here to explore the Format tab in detail. Explore customization options to modify ranking settings, adjust axis properties, configure gridlines, and fine-tune number formatting to meet your needs. Dive into each section to unlock advanced styling and formatting possibilities.
The Action settings allow you to define interactivity within your report for all visuals. This feature lets you enable or disable cross-filtering capabilities, giving you control over how the visual interacts with others.
None:
Disables interactivity for the selected visual.
When selected, interacting with the visual will not impact or filter other visuals in your report.
Cross Filtering:
Enables cross-filtering functionality.
Interacting with the visual will dynamically filter related visuals, allowing you to analyze specific data points or categories more effectively.
This is common tab for all visuals click here to explore settings. You can adjust visual properties, manage formatting options, and fine-tune various features to align with your requirements. Make sure to explore each section for a complete configuration.
