Configure a Stacked Bar Chart SQL Template
A stacked bar chart represents data with vertical bars. Rather than individual bars per data point, the values are stacked within a single bar. This type of chart can display bars only or it can be configured to include a line that will be charted on the right y-axis. Bar charts are available as two types:
Dynamic: With this type of chart, you don't need to know how many distinct values are available. Typically, this means that you not select colors for the bars, but let the system select them. In some cases, colors are available for selection for a limited set of known values. A dynamic chart requires 1 Caption, 1 Bar and 1 Legend.
Static: With this type of chart, you pre-define only the values and colors that you want represented in the chart - typically, a subset of the full set of values. A static bar chart requires 1 Caption and at least 1 Bar.
Bar charts are all similar and rendering can be easily changed from one orientation to another (horizontal or vertical) or from stacked to individual bars. Once a SQL Template is developed for a bar chart, simply select the