The selection procedure in charts and tables has been designed to be as intuitive as possible. In most cases you will find it possible to make selections directly in the chart plot area by clicking individual values (bars etc.) or by “painting” over a larger selection.
If you find that you cannot make selections in a chart as indicated, the chart may be in Detached mode or Read Only mode.
Selections in Bar, Line, Combo, Radar, Grid and Scatter charts
Selections can be made inside the plot area by clicking on a single data point or painting over several data points. When painting, a green raster indicates the selection until the mouse button is released. The selection will be made for the dimension values used for calculating the selected data point(s).
Selections can be made by clicking or painting in the chart legend (except when the legend is indicating chart expressions rather than dimension values).
Selections can be made by clicking or painting over the dimension axes and its labels (except scatter charts). The corresponding field values will be selected.
Selections can be made by painting over the expression axes and its labels. The field values which generate data points in the indicated result area will be selected.
Selections in Pie charts
Selections can be made inside the plot area by clicking on a single pie slice or painting over several slices. When painting, a green raster indicates the selection until the mouse button is released. The selection will be made for the dimension values used for calculating the selected data point(s).
Selections can be made by clicking or painting in the chart legend.
Selections in Block charts
Selections can be made inside the plot area by clicking a single block or by painting over several blocks. When clicking, selections are made with drill-down functionality so that the first click selects a single value in the 1st dimension. Clicking a second time (i.e. within the selection) selects a single value in the 2nd dimension and so on.
When painting, a green raster indicates the selection until the mouse button is released. The selection will be made for the dimension values used for calculating the selected data point(s). By painting across the boundaries of several values of the 1st dimension, all sub-values of the 2nd and 3rd dimensions belonging to these values are selected, not just the ones touched by the selection.
Selections in Gauge charts
Selections cannot be made in gauge charts.
Selections in Straight tables
Selections can be made in the dimension columns by clicking on a cell or painting over several cells. The selected area is marked green until the mouse button is released.
Selections can be made in the expression columns by clicking in a single cell. The selection will be made for the dimension values used for calculating the selected expression cell.
Selections in Pivot tables
Selections can be made in the dimension columns/rows by clicking on a single cell. The selected cell is marked green until the mouse button is released.
Selections can be made in the expression columns/rows by clicking in a single cell. The selection will be made for the dimension values used for calculating the selected expression cell.
Selections in Table boxes
Selections can be made by clicking in any cell or by painting over an area covering one or more rows and one or more columns. The selected area is marked green until the mouse button is released.
