Stacked Area Charts
Output
A Stacked Area Chart is similar to a Pie Chart in that it show what percentage of a data element accounts for the whole. Unlike a Pie Chart, however, it can break out this data across a dimension.
There are two methods of creating a Stacked Area Charts
1. Drag and Drop
- Drag one column into the Dimension Area
- Drag one numeric column into the Measure Column. The Measure column allows you to use aggregate function such as Sum, Count, Average, etc…
2. SQL Query
An Example Stacked Area SQL Query:
SELECT COL1, COL2 FROM TABLE GROUP BY COL1
In the above SQL query, COL1 is dimension column and COL2 is the numeric column.
SQL mode also supports citql tags so you can easilt add interactivity to your reports.