Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam
A Combination Chart can be created when 2 or more Measures appear in either the Columns or Rows decks. Each Measure receives its own Chart Properties item to allow choosing a Chart Type specific to that Measure.
To create a Combination Chart:
1. Execute a select * from bistudio_example within the query analyzer on the bistudio_example.xlsx file
2. Click the [Visual Analytics] icon in the Query Analyzer Grid Results toolbar.
3. Drag DueDate from Dimensions to Columns.
4. Right click on DueDate in Columns and select [Month] date grouping from the top half of the Date Grouping format options.
5. Drag Tax Amount, Freight and Profit from Measures to Rows.
6. Notice in the Chart Properties there are 3 additional rows (one each for Tax Amount, Freight and Profit).
7. Click on Tax Amount in the Chart Properties and select [Bar] for its Chart Type.
8. Click on Freight in the Chart Properties and select [Line] for its Chart Type.
9. Click on Profit in the Chart Properties and select [Line] for its Chart Type.
10. Click on [All] at the top of the Chart Properties. Its Type should now indicate Multiple. Click its [Axes] button and select [Merged Axes].
11. You should now see a Combination Chart that includes lines for Freight and Profit, as well as vertical bars for Tax Amount.
The charts are layered on top of one another with the right most Measure in the Rows or Columns deck appearing on top. Drag them into new positions to stack the chart layers how you like.
Cell Space in Combination Charts
When a Combination Chart is created, measures in the chart get their own Cell Space within a Field label. Cell Spaces for a Field Label are rendered in the same physical area in a Combination Chart to allow overlays of Chart Types in the same View within a Merged Axis. Cell Spaces make possible displaying a Line Chart on top of a Bar Chart. In the case of multiple bars, multiple measures in the same Cell Space are rendered in the same location.
This may make it appear that some of your measures are not being rendered, when in fact they are. Changing which measures appear farthest right on your decks can assist in revealing them.