How to apply OR filter with filters from two combo boxes?

When working with filters in dashboard, you may want to apply an OR condition between two combo boxes. This can be achieved by creating two dashboard parameters and utilizing them in your code view or data filters. Here’s a step-by-step guide on how to implement this:

Steps to Apply OR Filter

1. Create Dashboard Parameters:

   • Start by creating two list dashboard parameters for utilizing it in dashboard parameters.

2. Use in Code View:

   • In the code view, you can incorporate these parameters into your WHERE condition. This allows you to filter the data based on the selections made in the combo boxes.

                          or
     

Use in Data Filters - Implement OR Condition:

• When setting up your data filters, ensure that you use the OR condition to combine the two parameters. This will allow the dashboard to display data that meets either of the criteria specified by the combo boxes.

4. Use Parameters in Combo Boxes:
   • Finally, drag the created dashboard parameters to the respective combo boxes. This ensures that the selections made in the combo boxes directly influence the data displayed on the dashboard.

Example

Assuming you have two combo boxes for filtering by “Category” and “Status”, you would create two parameters, say CategoryParam and StatusParam. In your code view, you would set it up as follows:

WHERE Category = :CategoryParam OR Status = :StatusParam

This SQL-like syntax allows the dashboard to filter records that match either the selected category or status.

Conclusion

By following these steps, you can effectively apply an OR filter using two combo boxes in your dashboard. This enhances the interactivity and usability of your data visualizations.

Additional References

• Configuring List Dashboard Parameters
• Code view mode
• Data Filters