Create a dynamic filter

There are two types of dynamic filters: one that uses an existing list of values and one that uses a list that you define.

Use an existing list of values (list field)

To create a dynamic filter that uses an existing list of values, you must select a list field. The field's list values become the filter options that users can select in the dashboard report.

  1. Choose Actions > Edit Report.
  2. In edit mode, beside Filters, click the edit button .
  3. In the filter editor, click the Add Dynamic Filter button.
  4. Enter a name for the filter.
  5. From Field, click the drop-down list and select a list field.
    In this example, the existing values for the list field, Status, populate the filter editor and In Progress and Completed are selected by default.
  6. (Optional) To make a value the default selection when a user applies the filter, select the checkbox beside it.
  7. (Optional) To reorder the list of values, click the row's gripper and drag the row to a new location.
In the report, the existing values for Status are displayed as filter options. The gray dots indicate the default selections.

Use a list you define (single-value field)

To create a dynamic filter that uses a list you define, you must select a single-value data field, and then enter a list of criteria. The criteria becomes the filter options that users can select in the dashboard report.

  1. Choose Actions > Edit Report.
  2. In edit mode, beside Filters, click the edit button .
  3. In the filter editor, click the Add Dynamic Filter button.
  4. Enter a name for the filter.
  5. From Field, click the drop-down list and select a single-value data field.
  6. Click Select a condition, enter a value for the condition, and enter a name to display for the filter option. If necessary, add more conditions. For a list of filter conditions, see Filter conditions.
    In this example, multiple conditions are defined for the field Project Estimated Hard Savings.
  7. (Optional) To make a value the default selection when a user applies the filter, select the checkbox beside it.
  8. (Optional) To reorder the list of values, click the row's gripper and drag the row to a new location.
In the report, the criteria you defined for the Estimated Hard Savings filter are displayed as options.

About the My Projects filter

The My Projects filter is a dynamic filter in the dashboard. It contains a default list of values that you cannot change:
  • Projects I Own
  • Shared with Me (Editor)
  • Shared with Me (Viewer)
However, you can change whether the My Projects filter is applied and which values are selected by default.
My Projects filter in a report
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy