Hide measure when re-visualizing

Contents[Hide]

1. Overview

This article describes how the Hidden property of a measure is used to prevent the measure from being visualized when it is used for comparison purposes only like in a state condition.

2. Walkthrough

Create a new metric set with one measure (OrderQty) and one row hierarchy (Product).

Initial metric set
Initial metric set

Create a new state group on the OrderQty measure and add a new state. Add a condition to the state to compare the measure against a Constant value.

Add a state
Add a state

Use Greater Than as a comparison operator and set the constant value to 50000. Click Submit to add the state.

Compare against a constant value
Compare against a constant value

The metric set visualization displays the state and you can see that a second measure Constant (50000) has been added to the metric set. This measure is not visualized as a regular measure because it is used only for comparison purposes as part of a state condition.

Visualize the metric set and state
Visualize the metric set and state

Go to the toolbar and re-visualize the bar chart as a table. You'll see that the resulting table still only shows one measure (instead of two) and one state.

Re-visualize as a table
Re-visualize as a table

Edit the Constant (50000) measure. In the Configure Metric Set Element dialog, scroll down to find the Hidden property which is set for this measure. This property is used to hide measures such as this one that are used soley for comparison purposes (e.g., as part of a state condition).

Hidden property
Hidden property

3. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri