Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Parameters Pane, which appears below the Measures Pane, is for creating your own dynamic values that can take the place of constant values in calculations. See the Parameters page for more on how to create and work with parameters.

Converting Measures to Dimensions, Converting Dimensions to Measures

There may be cases where you need to convert what Visual Analytics detected as a Measure into a Dimension (or vice versa). As an example, data in the field ShipVia may be stored as numbers 1, 2, 3, or 4 where each number was meant to represent a different shipping method like air, sea, road or rail. Visual Analytics would detect these digits and assume ShipVia is a Measure. To convert ShipVia to a Dimension, right-click on it within the Measures Pane and select [Convert to Dimension].

...

Once the Measure is converted it appears in the Dimensions pane.

Renaming Dimensions and Measures

You can right-click on a Dimension, Measure, Calculated Field, or Parameter and select [Rename...] to provide a custom name. A Dimension or Measure's name in the data source remains unchanged when you use [Rename...], renaming merely provides an alias to the original data source name within Visual Analytics.

...

Info

Be aware that renaming a Dimension, Measure or Parameter can cause a Calculated Field to become invalid if it expects to use a particular field name that no longer exists in its calculations. You will get a warning if your field is in use within a Calculated Field before you rename it.

Viewing Data

To view the data associated with the Dimensions and Measures, click the [View Data] button at the top right of the Dimensions pane. This will show all of the data in a tabular format. For more on the View Data window, see Viewing Data.

Searching Dimensions and Measures

To search for a particular Dimension or Measure click the [Search] icon at the top right of the Dimensions or Measures pane. Names will be matched in alphabetical order as you type and highlight with a background color in the list.

...