The requirements for Stacked Bar Chart widgets are the same as described above for the Pie Chart widget with these exceptions:
-
Bar Chart queries, or Dataspies if you use a grid, must return two columns but may return additional columns up to a total of 50.
-
The first column defines the x-axis. Feel free to use an alias again in your query.
-
The remaining columns must be numeric and determine the size of the sub-bar or categorial value. For these columns it is recommended you define a column alias. This alias will be displayed on the widget when you hover over the sub-bars or categorial value.
Bar Chart widgets are also equipment sensitive, like the Pie Chart widget.
For some sample queries to get you started see later in this document.
On top of the user defined grids, the standard cost for equipment grid is also available for use with this widget.