Charts

You can select from a number of different chart types, and you can set different levels of aggregation for rows and columns. You can change a field from a column to a row, pivot a chart, hide chart values, and zoom in to see chart details.

Fields and Measures

You must add at least one measure to view a chart. Before any measures are added to the chart, the Ad Hoc Editor displays a placeholder with the legend that displays a single entry to add a measure to continue. As you add measures, the editor displays the grand total of each measure in the chart.

The initial display reflects only 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. You can add, remove, and arrange measures and fields without waiting for the display to update. When you have the fields and measures you want, you can use the sliders to select the level of detail you want.

All available fields are listed in the Data Selection pane in the Ad Hoc Editor, 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. You can add one or more measures to the chart as columns, or add one or more measures to the chart as rows. You cannot have one measure as a column and another as a row in the same chart.