Define Filtered Variables

For Administrators only

Filtered variables can be used to restrict the data a user has access to by filtering for attributes like Region, Department, or Industry. Filtering for Region could be useful for preventing certain users from seeing confidential data that does not pertain to their job. Filtering for Department or Industry could be useful for hiding extraneous data that doesn't pertain a given team's activities.


Define a Filtered Variable


  1. Click Manage on the project toolbar.
    The administration page opens.
  2. On the Data tab, click Variables.
    The list of all project variables opens.
  3. Click Create Variable.
  4. Enter a name for the variable. Click Ok.
  5. For the variable type, click the Filtered Variable checkbox.
  6. Select the attribute you are interested in filtering.
  7. Select the default attribute values that should be included or excluded from the calculation of a user's report values. If no default values are set, users can access data associated with any attribute value, including any new attribute values added later to the project.
    Selecting values that filter allows into report computations

    The All or None selections for the attribute values apply to any new values for this attribute that are added to the project in the future.

  8. (Optional) Customize the attribute values to be filtered for specific users. Under User-Specific Values, click the Choose link.

  9. To modify values that have already been defined, click the current filtered value next to a user's name.
  10. When done with configuring the variable, click Save Changes.

Incorporate a Filtered Variable

You can incorporate filtered variables into project reports using the following methods:

Add a Variable Filter to a Dashboard

For more information, see Filter for Variables.

VIDEO - How to Set Up Filtered Variables