Interactive data filtering in Statistica Enterprise

Interactive data filtering in Statistica Enterprise

book

Article ID: KB0074186

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.0 and higher

Description

With interactive data filtering, you can specify filter criteria whenever an Analysis Configuration is run. The criteria for interactive data filtering are specified on a field-by-field basis in the Data Configuration. This article shows an example of creating interactive filtering in a data configuration.

Environment

Windows

Resolution

For example, consider the set-up in the following image.

This is a Data Configuration that contains 3 fields: TM, Category, and FlowTwo. TM has Target Type = Time Stamp, and FlowTwo has Target Type = Variable Characteristic.
 
Suppose you want to set up interactive filtering by the values in the Category field.

1. Select Category in the tree view.

2. In the properties page, click the Filtering button.

3. In the Filter Options properties page, select the top Enabled check box.
 
4. In the Hierarchical Filtering group box, select the Sequence Number option button and accept the default value of 1.

5. Select the Required when Filtering check box.

6. Save the Data Configuration.

Now, when you run an Analysis Configuration that is based on this Data Configuration, you will be prompted to select a value from the Category field.

7. Click the ... button to display the Value of Category dialog box, which contains a list of the unique values in that field.

8. Select B and click OK. The SQL Criteria dialog box is displayed.

9. Only records where the Category field = B will be returned. Click Finish to run the analysis.

Now look at the spreadsheet of retrieved data.

Notice that only the records with Category = B were returned, and the SQL statement Where clause information is placed into the spreadsheet header.

Issue/Introduction

Interactive data filtering
Powered by Wolken Software