The Bar Chart is one of the most versatile and useful chart types in Labelf Analytics. It is perfect for comparing values between different categories, and with the right settings, you can customize it to display a variety of different types of information.
Set up the Bar Chart
Du skapar ett enkelt Bar Chart genom att välja ditt dataset och Bar Chart som diagramtyp:
Metric: What you want to measure (e.g. COUNT(*), SUM(sales), AVG(order_value)).
X-Axis: What you want to be on the x-axis of the graph by (e.g. product_category, region, month).
Time Grain: If you have a time dimension, select the time unit (day, week, month, etc.)
Below is an example of the number of customer contacts per month (month as time grain)
Dimension: Dimension is used to group the data further from the grouping that occurs along the X axis. This can be done to distinguish, for example, what type of needs customers have had in the interactions
Below we see an example of this where we have also set the graph to be stacked (done under customize)
But that's just the beginning! Let's look at some of the advanced settings and variants of the Bar Chart.
Advanced Settings
Filters: Use filters to limit the data displayed in the chart.
Example: Only show data for a certain time period, a certain product category, or customers in a certain region.
Row Limit: Limit the number of bars displayed. Useful if you have many categories.
Example: Show only the 10 products with the highest sales.
Avancerade Inställningar (Customize-fliken)
Stacked Bars:
What it is: Bars are stacked on top of each other instead of being displayed side by side. Used to show how a whole is divided into parts.
When to use it: When you want to show both the total amount and the breakdown between different categories.
Hur: Under "Chart Options", markera kryssrutan "Stacked Bars".
How: Under “Chart Options”, check the “Stacked Bars” checkbox.
Horizontal Bars:
What it is: The bars are displayed horizontally instead of vertically.
When to use it: When you have long category names, or when you prefer the horizontal format.
How: Check “Horizontal” under "Customize"-“Bar Orientation”.
Show Values:
What it is: Shows the exact values (numbers) of the bars.
When to use it: When it is important to be able to read the exact values.
How: Check the “Show Values” checkbox.
Tip: Can make the chart messy if you have many bars.
Y Axis Label / X Axis Label:
What it is: Customize the text on the axes.
When to use it: Always! Make it clear what the chart shows.
How: Enter the desired text in the “Y Axis Label” and “X Axis Label” fields.
X Axis Bounds:
What it is: Set the min and max values for the x-axis.
When to use it: To focus on a specific range, or to ensure that multiple charts have the same scale.
How: Enter the desired values in the “Min” and “Max” fields.
Color Scheme:
What is it. Change the colors.
When to use it? You can match the colors with your graphic profile, or use colors that reinforce the message.
How: Choose a color scheme from the dropdown menu.
Number format
What. How do you want your numbers to be presented?
When to use it? When you want to change the format of the numbers, for example to show percentages, round off decimals, or add currency symbols.
How: Enter the format.
Contribution
What is it? Displays the percentage of the total for each bar, instead of the absolute value..
When to use it? When you are more interested in proportions than in the exact numbers.
How: Under “Data” - "Query" select “Contribution Mode”.
Show Legend
What is it. Shows an explanation of what the different bars/colors mean.
When to use it? Used when you have multiple dimensions.
How: Check “Show Legend”
Avancerade Analysverktyg (Advanced Analytics)
Under the tab “Advanced Analytics” you will find additional functions that can be useful:
Rolling Window: Create moving averages (e.g. 7-day average) to smooth out trends and reduce noise.
Time Comparison: Compare data to a previous period (e.g. same period last year).
Examples of Bar Chart Variants
Grouped Bar Chart:
Data: Customer interaction by month and customer need.
Settings:
Metric: count_distinct(contact_id)
X-Axis: interaction_date
Dimensions: customer_need
Stacked: Off
Result: Result: Bars grouped by region, with one bar for each product category within each month.
Stacked Bar Chart:
Data: Resolution rate of customer interactions broken down by customer need
Inställningar:
Settings:
Metric: Count_distinct(contact_id)
X-axis: Customer need
Dimension: resolution_status
Stacked Bars: On
Result: One bar per customer need, where each bar is divided into resolution_status
Bar chart with Contribution:
Data: Resolution rate for customer interactions broken down by customer need with contribution
Settings:
Metric: Count_distinct(contact_id)
X-axis: Customer need
Dimension: resolution_status
Stacked Bars: On
Contribution: On
Result: One bar per customer need, where each bar is divided into resolution_status and each status contrubutes up to 100%
Reminder:
These are just a few examples of what you can do with Bar Charts in Labelf Analytics.
Experiment! Try different settings and combinations to find what works best for your data and your questions.
Use Labelf's documentation and help functions if you get stuck.
By mastering the different settings and variations of Bar Chart, you can create powerful and informative visualizations that help you understand your data and make better decisions.