You must add at least one measure to view a chart. Before any measures are added to the chart, the Report Editor displays a placeholder with the legend displaying a single entry: Add a measure to continue. As you add measures, the editor displays the grand total of each measure in the chart.
The initial display only reflects the measures you add; it does not change when you add fields or dimensions. For example, for each measure you add to a bar chart, you see a bar with the total value of the measure, regardless of how many fields you add. This means you can add, remove, and arrange measures and fields without waiting for the display to update. Once you have the fields and measures you want, you can use the sliders on the right to select the level of detail you want.
All available fields are listed in the Data Selection panel, as either standard fields or measures.
- Standard fields can be added to a column or a row.
- Measures contain summarized values. They are typically numeric fields that determine the length of bars, size of pie slices, location of points (in line charts), and height of areas. They can be added to rows or columns, but must all be in the same target — that is, you can add one or more measures to the chart as columns, or add one or more measures to the chart as rows, but you cannot have one measure as a column and another as a row in the same chart.
When creating a chart, keep in mind that row and column groups are arranged in hierarchies, with the highest member of the hierarchy on the left.
- For a Report view based on an OLAP data source, you can change the order of distinct dimensions by dragging, but you cannot change the order of levels within a dimension.
- For a Report view based on a non-OLAP data source, you can drag the field headings to rearrange the hierarchy; the highest level in a group should appear to the left; the lowest level in a group should appear to the right. For example, it doesn’t make sense to group first by postal code then by country, because each postal code belongs to only one country.
To add a field or measure to a row or column:
- In the Data Selection panel, select the field you want to add to the chart as a group. Use Ctrl-click to select multiple items.
- Drag the selected item into the Columns or Rows box in the Layout Band.
Did this article help?
Please provide us your feedback below.