Applying WHERE Conditions in Design Mode for Data Filtering
When working with data in design mode, it’s often necessary to filter data to display only the relevant information. This can be achieved through the use of WHERE conditions usually in SQL. This can also be accomplished in Bold BI design mode without the necessity of SQL coding. Here are two methods to apply WHERE conditions in design mode:
Using Query Joiner
To filter data after joining tables, you can use the AND filter within the join UI. This allows you to specify conditions that the data must meet to be included in your results.
Steps to Apply WHERE Conditions Using Query Joiner:
- Join the tables that you need for your data analysis.
- Once the tables are joined, navigate to the join UI where you can add filters.
- Add an AND/OR/NOT, etc. condition by selecting the appropriate fields and specifying the values you want to filter by.
- Ensure that the fields selected in the AND condition are the same to maintain consistency and accuracy in your data.
Note: It is crucial to select the same fields in the AND condition to avoid any discrepancies in the data.
Using Data Filters
Another method to apply WHERE conditions is by using data filters. This feature allows you to set up filters that will be applied to the data as soon as it is loaded into the design mode.
Steps to Apply WHERE Condition Using Data Filters:
- Access the data filters section in your design mode settings.
- Configure the filters by selecting the fields and specifying the conditions for the data you want to include.
- Save the filters to ensure they are applied every time the data is loaded.
For detailed assistance on configuring data filters, please refer to the following help documentation: Configuring Data Filters
By using these methods, you can effectively apply WHERE conditions to your data in design mode, streamlining your data analysis process without the need for direct code manipulation.
Additional References
