Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Step 3: Defining Analytics Prompts (Optional) > Adding Column Filter Prompts in Analytics

Adding Column Filter Prompts in Analytics

A column filter prompt allows users to select values to filter a column in an analysis. You can define the range of possible filter values and how the user selects the filter values for the analysis.

You define column filter prompts in the Prompts tab. When you have multiple column filter prompts constructed for an analysis, they are presented to the user one at a time, in the order they are listed, from top to bottom.

Note: Prompts only appear when you open a saved analysis. You cannot preview them in the Criteria, Results, or Prompts tab while editing or defining analysis.

To add a column filter prompt

1. In the Prompts tab, click the New icon, select Column Prompt, and then choose a column.
2. The label for the prompt is the name of the selected column, but you can use a custom label if you prefer.
   1. To create a custom label, select the Custom Label check box.
   2. In the Label field, edit the existing column name with your new custom label.
3. Enter a description in the Description text box (optional).
4. In the Operator drop-down menu, choose a comparison operator, such as equal to, is greater than, or begins with.
5. In the User Input drop-down menu, choose a method for the user to select a value to filter by. The choices include:
   • Text Field (for direct entry of a filter value)
   • Choice List (the application displays a drop-down menu with all possible values and the user must choose one value)
   • Slider (the application displays a slider (with your specified minimum and maximum values) and the user must adjust the slider.
   • Check Boxes (the user can select one or more than one value.)
   • Radio Buttons (the user must select only one value)
   • List Box (similar to Choice List, but the choices are displayed in a list box instead of a drop-down menu)

     Some choices for User Input require further specification in the Options pane.

6. Use the Options pane to further define the user input, such as specifying minimum or maximum values, and so on.
7. When you are finished, click OK.

   The column filter prompt is shown on the Display pane.