| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Interactive Charting"
| (7 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | Please see [[Small Multiple Charts]] for full details. | |
| + | |||
| + | Version 7.5 provides the ability for more interactive, chart-driven reporting. This is achieved by extending the existing [[Small Multiple Charts]] in the product. Users can now click a chart, or a datapoint within a chart and have the rest of the report update in context, as in the example below where Road Bikes, Q2 has been selected and the ranking table beneath has been filtered accordingly. | ||
[[Image:ic.png|350px]] | [[Image:ic.png|350px]] | ||
| Line 11: | Line 13: | ||
When building reports, it's now possible to track any selected element of a Small Multiple Chart. This includes an axis element, an individual chart, or any data point in the chart. This information can be output to a range of Excel cells, and then other parts of the overall report, including grids and formulae, can be based on the content of these cells. The chart will also indicate by colour which chart or datapoint is selected. This is handled by all unselected elements being displayed in a much lighter shade, while the selected item retains the original colour. | When building reports, it's now possible to track any selected element of a Small Multiple Chart. This includes an axis element, an individual chart, or any data point in the chart. This information can be output to a range of Excel cells, and then other parts of the overall report, including grids and formulae, can be based on the content of these cells. The chart will also indicate by colour which chart or datapoint is selected. This is handled by all unselected elements being displayed in a much lighter shade, while the selected item retains the original colour. | ||
| − | [[File: | + | [[File:SMInteraction.png|400px]] |
These output properties are configured in the properties for the chart control, as shown in the screenshot. To track an element, select the relevant checkbox and chose the desired output cell. | These output properties are configured in the properties for the chart control, as shown in the screenshot. To track an element, select the relevant checkbox and chose the desired output cell. | ||
| Line 21: | Line 23: | ||
=Chart Formatting= | =Chart Formatting= | ||
A more granular level of control is now provided for the axis and chart name elements within the chart control. This is available in properties as shown below. | A more granular level of control is now provided for the axis and chart name elements within the chart control. This is available in properties as shown below. | ||
| − | [[File: | + | [[File:SMTitleAxis.png|400px]] |
=SQL and Excel sourced Charts= | =SQL and Excel sourced Charts= | ||
7.5 introduces the capability to build small multiple charts from non-cube data. This can be any Excel range, or directly from a SQL query or stored procedure. When inserting a small multiple chart from the XLCubed ribbon, you can now specify which data source this is for. | 7.5 introduces the capability to build small multiple charts from non-cube data. This can be any Excel range, or directly from a SQL query or stored procedure. When inserting a small multiple chart from the XLCubed ribbon, you can now specify which data source this is for. | ||
| + | * [[Small Multiple Charts based on SQL]] | ||
| + | * [[Small Multiple Charts based on Excel Ranges]] | ||
| + | |||
| + | [[Category:Small Multiple Charts]] | ||
| + | [[Category:Visualisations]] | ||
Latest revision as of 10:06, 26 October 2018
Please see Small Multiple Charts for full details.
Version 7.5 provides the ability for more interactive, chart-driven reporting. This is achieved by extending the existing Small Multiple Charts in the product. Users can now click a chart, or a datapoint within a chart and have the rest of the report update in context, as in the example below where Road Bikes, Q2 has been selected and the ranking table beneath has been filtered accordingly.
Small Multiples have been extended in three key areas:
- Full control over selected chart and chart area, with associated formatting
- More control over axis and title formatting
- In addition to cubes, Small Multiple charts can also be built from an Excel Range or directly from SQL.
Chart Selections
When building reports, it's now possible to track any selected element of a Small Multiple Chart. This includes an axis element, an individual chart, or any data point in the chart. This information can be output to a range of Excel cells, and then other parts of the overall report, including grids and formulae, can be based on the content of these cells. The chart will also indicate by colour which chart or datapoint is selected. This is handled by all unselected elements being displayed in a much lighter shade, while the selected item retains the original colour.
These output properties are configured in the properties for the chart control, as shown in the screenshot. To track an element, select the relevant checkbox and chose the desired output cell.
'Link to' is also available as an option, where the focus can be moved to another area of the report in the context of the selected chart or chart element.
Chart Formatting
A more granular level of control is now provided for the axis and chart name elements within the chart control. This is available in properties as shown below.
SQL and Excel sourced Charts
7.5 introduces the capability to build small multiple charts from non-cube data. This can be any Excel range, or directly from a SQL query or stored procedure. When inserting a small multiple chart from the XLCubed ribbon, you can now specify which data source this is for.
