Step 4: Filtering the analysis

You can use filters to limit the results that are included in the analysis. Filters allow you to limit the amount of data displayed in the analysis and are applied before the analysis is aggregated. Filters can be applied directly to attribute columns and measure columns.

We will filter our analysis so that it only includes information for emails that were actually sent.

To filter the analysis:

  1. Click the Criteria tab.
  2. In the Filters area, click The New Filter icon Filter then click Total Sends. The New Filter dialog appears.

    This image shows the New Filter dialog

  3. Select is greater than / equal to from the Operator drop-down list.
  4. Type 1 in the Value text box and click OK. The filter is added to the analysis.

    This image shows the new filter on the canvas

  5. Click Filter and select Campaign Product.
  6. For the Operator, select is prompted, and click OK.
  7. Repeat steps 5-6 for Campaign Name and Day.

    Once an attribute has the is prompted filter, it can be used in dashboard prompts.

Tip: Spaces are treated as characters in filters. Avoid spaces if they are not part of your filter criteria. For example, the following two filters are treated differently because of spaces:

  • "example1.com; example2.com"
  • "example1.com;example2.com"

Next step

Step 5: Changing the display of the analysis