How to Filter dashboard view using Grouped URL Parameters in Bold BI

The Grouped URL Parameters feature in Bold BI enhances the filtering capabilities of dashboards by allowing users to combine multiple conditions using AND/OR operators. These conditions are enclosed in parentheses to define how they should be combined, providing flexibility to control what data is displayed.

How It Works

To utilize the Grouped URL Parameters, users can define the logical grouping of their filter conditions by enclosing them within parentheses. This helps in specifying how different filtering conditions relate to each other.

Sample data:

Example of a Grouped URL Parameter

Here’s a structural outline of how the URL should be formatted:

Syntax:

http://<servername>/<culturename>/dashboards/<dashboardid>/<category>/<dashboardname>?(((Condition1)&(Condition2))|(Condition3))

Example:

http://localhost:58192/bi/site/site1/dashboards/75602bb6-985b-4abb-902a-3d40aecd7c8e/categoryname/dashboard?(((CustomerID=ALFKI&OrderID=10643)&City=Berlin)|(ProductName=Aniseed Syrup&Country=Austria, USA))

• Conditions within parentheses: The filters are strategically grouped using parentheses.
  • Group 1: Here, (CustomerID=ALFKI & OrderID=10643) & City=Berlin. Displays orders where CustomerID is ‘ALFKI’, OrderID is ‘10643’, and the City is ‘Berlin’. The AND operator ensures that all conditions must match.
  • Group 2: Here, (ProductName=Aniseed Syrup & Country=Austria, USA). Displays orders where ProductName is ‘Aniseed Syrup’ and the Country is either ‘Austria’ or ‘USA’. The OR operator between groups ensures that records matching either Group 1 or Group 2 are shown.

Output in Bold BI:

Grouped Parameters in Action:

Based on the above URL and data:

• Orders by ALFKI in Berlin with OrderID = 10643 are shown.
• Aniseed Syrup orders from Austria or USA are also displayed.

Customization of Conditions

Users can change the conditions in the URL to fit their needs. This flexibility helps create specific filters that match different analysis goals, allowing for clearer insights from the data.

Additional References

• Grouped URL parameters in Bold BI
• Limitations of URL parameters