Condition Editor

You can add elements to Custom Groups and place conditions on those elements using the Condition Editor, which is accessed from the Custom Group Editor. To display the Condition Editor, click the Add New Custom Group Element icon.

 

You can define the following types of conditions:

Attribute qualification: Restrict data based on the value of an attribute form, view data only for attribute elements in a list, or compare two attribute forms to filter data.

Set qualification: Restrict data based on the value, rank, or percentage of a metric, or by comparing the values of two metrics.

Shortcut to a report: Restrict data using the results of an already existing report.

Shortcut to a filter: Restrict data using an already existing filter.

Shortcut to a prompt: Restrict data using the answers to an already existing prompt.

The table below provides steps to define a filtering condition for a selected custom group element.

 

Goal

Steps

Filter data based on the value of an attribute form

  1. Click Browse, then locate and select the attribute to use to filter data.

  2. Select the attribute form you want to filter data based on.

  3. Select the operator that describes how you want to filter data, such as Begins With or Less Than.

  4. Do one of the following:

    • To filter data based on a date, select a date from the calendar. This is the value that will be compared to the selected attribute form above.

    • To filter data based on a value that is not a date, type the value in the field. This is the value that will be compared to the selected attribute form above.

  5. Depending on the operator you selected from the previous drop-down menu, you may need to select additional values. For example, the operator Between requires two values.

  6. Click OK to return to the Custom Group Editor.

Include or exclude data for attribute elements in a specified list

  1. Click Browse, then locate and select the attribute to use to filter data.

  2. Do one of the following:

    • To include data only for attribute elements in a specified list, select In List.

    • To exclude data for all attribute elements in a specified list, select Not In List.

  3. Click Browse elements. A list of attribute elements is displayed.

  4. Select the attribute elements for which you want to include or exclude data.

  5. Click OK to return to the Custom Group Editor.

Filter data by comparing two attribute forms

You can compare:

  • The attribute forms of two different attributes

  • Two different attribute forms of a single attribute

  1. Click Browse, then locate and select the first attribute to use to filter data.

  2. Select the attribute form you want to filter data based on.

  3. Select the operator that describes how you want to filter data, such as Equals or Does not equal.

  4. Click Select attribute, then locate and select the second attribute to use in the comparison.

  5. Select an attribute form for the second attribute. This is the value that will be compared against the form of the first attribute.

  6. Click OK to return to the Custom Group Editor.

Filter data based on the value of a metric

  1. Click Browse, then locate and select the metric to use to filter data.

  2. Select the operator that describes how you want to filter data, such as Equals or Does not equal.

  3. Type the value in the field. This is the value that will be compared against the selected metric.

  4. Click Select attribute, then locate and select the attribute to use for the output level for the condition.

  5. Click OK to return to the Custom Group Editor.

Filter data by comparing the values of two metrics

  1. Click Browse, then locate and select the first metric to use to filter data.

  2. Select the operator that describes how you want to filter data, such as Begins With or Less Than.

  3. Click Select metric, then locate and select a second metric. This is the value that will be compared against the first metric.

  4. Click Select attribute, then locate and select the attribute to use for the output level for the condition.

  5. Click OK to return to the Custom Group Editor.

Filter data using a report

  1. Click Browse.

  2. Locate and select the report object to use to filter data.

  3. Click OK to return to the Custom Group Editor.

Filter data using a filter

  1. Click Browse.

  2. Locate and select the filter object to use to filter data.

  3. Click OK to return to the Custom Group Editor.

Filter data using a prompt

  1. Click Browse.

  2. Locate and select the prompt object to use to filter data.

  3. Click OK to return to the Custom Group Editor.

 

Related topic

Custom Group Editor

Select Elements dialog box

 

 

_____________________________