Working with Filters in Query Designer
Applying filter is a good option to limit the data viewed without altering the design of the underlying object. Filter allows you to see only the data you want displayed.
-
Object Filters: Simple Filter and Advanced Filter.
-
Query Filters: Advanced Filter
Applying Simple Filter to Your Query
Context
Use Simple Filter on an object to limit the records from one or more of its selected columns.
Procedure
Results
Configuring Date Range in Time Filter
You can retrieve data from a selected schema table for a defined duration by configuring and applying the Date Range option of time filter.
Context
This configuration applies when you use a Time Filter with the Date Range option. To get to the date range configuration dialog, select a schema table on the query canvas, click , (remove existing filters, if any), and select . The Set Date Range dialog appears.
Procedure
Results
Advanced Filter
Advanced filtering allows you to filter multiple data fields by defining a set of logical conditions. To apply advanced filter, select the object of your choice. From the contexual menu, select . Add new conditions from the button, choose either dimensions or operators to create nested filters.
Applying an Advanced Filter
Advanced filtering allows you to filter multiple data fields by defining a set of logical conditions.
Context
Advanced filtering mainly uses AND or OR conditions to filter the data fields. These conditions can be set to Include or Exclude the data that satisfies the filter conditions.
Add new conditions using the "+" button, and choose either fields or operators to create nested filters.
Currently, advanced filtering can be used on both queries and stories. You can apply an advanced filter for an entire story page or on individual widgets. The option for advanced filters is enabled only after you add at least one table to the query canvas or one chart to the story page.
Procedure
Results
Creating Input Parameters for Advanced Filtering
Make your data filtering more flexible using parameters in advanced filters.
Context
Parameters enable you to update your filter easily. Using Edit Prompts in Story, you can prompt users to provide filter inputs during story execution.

