Creating a Stacked bar Chart

In this guide, we'll walk you through the process of creating a Stacked bar Chart. This type of chart is best used to represent and compare categorical data across multiple categories .The bar is then divided into segments, each representing a category, and the length of each segment is proportional to the value of that subcategory within the overall category. The segments are stacked on top of each other to show the composition of the category.

We have two ways of creating a stacked bar chart.

Let's get started!

1. Access the Dashboard
2. Choose the Chart Type
3. Add a Chart Tag
4. Add a Chart Title
5. Add a Chart Description
6. Configure Chart Options
7. Heatmaps Colors
8. Choose Type of X Axis
9. Add subqueries

First method - Using subqueries

1. Access the Dashboard

To start creating a Pie chart, you'll first need to access your dashboard folder. Dashboard folders are located on the right green sidebar of the Web App.If you don't have a dashboard yet, you'll need to create one by clicking on the yellow icon** Create dashboard**. Once you're in your dashboard, click on the plus (+) button under the Add chart

2. Choose the Chart Type

A dialog box will appear for you to select the type of chart you want to create. From the dropdown menu, select "Stacked bar chart"

3. Add a Chart Tag

Next, you'll need to add a chart tag. This tag should be unique and separated by underscores if it comprises of more that one word / letter e.g (w_s_v_s, Weekly/daily/monthly sales vs stock)

4. Add a Chart Title

Now, add a title for your chart. This title should represent what the chart is about. For example,you might choose a title like "Weekly/daily/monthly sales vs stock".

5. Add a Chart Description

Add a description for your chart. This helps other users understand what the chart is about and what the query does. For example, you might write "daily/weekly/monthly sales "

6. Configure Chart Options

In this step, you'll configure various options for your chart:

- Percentage: Toggle this on if you want to show the values as percentages.
- Force the Display of the Chart in Full Width: Toggle this on if you want the chart to extend to the full width of the chart.
-**Grouped mode**: When this is on, it means that the bars for the different values will not be stacked on tock of each other but presented as separate bars instead.

7. Heatmaps Colors

Choose the position of the legend. The Legend is helps providing context and clarity to the information being presented.

8. Choose Type of X Axis

Select the type of X axis based on your dataset. If you're aiming to display category values like sales per user, then Text will be applicable since you are aggregating per user.

However, if you are aggregating over time i.e. Day or Hour then the X axis will me Time .

9. Add subqueries

This method calculates the values to be displayed separately. Click on Add Option to add your first subquery. The label field should have the name of the value to be displayed




Sales subquery



Stock subquery




By this method, you don't need to define the main or row query.

Ensure that your query is structured correctly and returns the expected results.

Second method - Using the Row and Main Query

Row query
First you need to define what you want to use as your row query. This is the part you define the categories that will act as the labels of the different entities in the chart. For example in a chart where you want to compare daily sale and stock, in the row query you need to define the labels as 'Stock' and 'Sales'. See below,




Main query
In the main query, you need to define the X and Y axis in the main query but before that , you need to create subqueries that calculate the different entities separately in our case sales and stocks. The subqueries will be joined by the UNION ALL function. The X axis can be Time or Text depending on the filed used in the axis.



Final chart




Add filters accordingly to refine the data you want to display.

Updated on: 22/08/2023