Adding More Fields

You can add as many fields as necessary by dragging and dropping them on the different areas of the view. Once there are more fields in the view there are some extra options available. For example you can replace fields by dropping them on existing headers and axes in the view. Or, instead of replacing a field you can add measures to an existing axis. Finally, you can rearrange the rows and columns in the view.

  1. Adding Headers Using Dimensions
  2. Adding Axes Using Measures

Adding Headers Using Dimensions

You can add headers to a view by dragging a dimension and dropping it to either side of an existing header, or to the left of an axis. For example, in the view below you can add the Region dimension by dragging it and dropping it to the right of the product names.

As you hover over the view, a dotted black line indicates active areas where you can add headers.
If you drop Region, it adds a column for Region along the top of the table, and slices the data so that you see results for each region within each category.


Adding Axes Using Measures

You can add axes by dragging a measure and dropping it on an active area in the view. If an axis already exists in the view you can replace the existing axis, blend the new measure with the existing axis, or add a secondary axis.

Replace the Existing Axis

Drag the new measure to the top left portion of the axis in the view. A small square drop zone appears and a single axis icon displays to indicate that a single axis will be left when you drop the measure. In this case you are replacing one measure (Sales) with another (Profit).

Blend the Measures on Single Axis

You can show multiple measures on a single axis by dragging the new measure directly on top of the existing axis. Blending measures uses the Measure Names and Measure Values fields. See Measure Values and Measure Names. In the image below you are adding a second measure (Profit) to the existing measure (Sales) on the axis.

The result is a view with both measures plotted along a single axis. In this case, Sales is shown in gray and Profit is shown in purple.

Add a Dual Axis

Drag the field to the right side of the view to add the measure as a dual axis. Dual Axes are useful when you want to compare two fields that have different scales. In this case, blending the two axes would distort the view. Instead you can add a dual axis.

The result is a dual axis view where the Profit axis corresponds to the purple line and the Shipping Cost axis corresponds to the brown line.

You can add up to four axes to the view: two on the Columns shelf and two on the Rows shelf.  You can also turn a measure into a dual axis by selecting Dual Axis on the field menu after it has been added to a shelf.


 

No comments:

Post a Comment