Stacked Column Chart
A stacked bar chart, also known as a stacked bar graph, is a graph that is used to break down and compare parts of a whole. Each bar in the chart represents a whole, and segments in the bar represent different parts or categories of that whole. Different colors are used to illustrate the different categories in the bar.
There are two ways of creating this chart.
Method 1 : Drag and Drop Method.
Method 2: SQL Query
SELECT tblproducts.name, tblhosting.billingcycle, sum(tblhosting.amount) FROM tblhosting
INNER JOIN tblservers
ON tblservers.id = tblhosting.server
INNER JOIN tblproducts
ON tblhosting.packageid = tblproducts.id
where {citqlGlobalUnique|tblservers.name} AND {citqlGlobalUnique|tblproducts.name} AND {citqlGlobalUnique|billingcycle}
AND {citqlGlobalUnique|paymentmethod}
group by tblhosting.billingcycle
As with all reporting options, you can toggle between drop-and-drag and SQL.