Bahar's Portfolio WORK ABOUT ASK AI
 
 

Advanced Filter

An add-on feature for Discovery Boards, one of Workday’s analytics tools.

 
 
 
 

Background

Workday Discovery Boards is a BI self-service and ad-hoc analytics tool that enables business users to do ad-hoc analysis, and visualize their data in real time without heavy report-writing.

Advanced Filter feature was born out of the need for robust filtering in Discovery Boards that often led users to export data from Workday or exchange tooling for further analysis.


Design Objective

// How might we enable Financial Analysts to create AND/OR filters and combine them to further restrict the data when running reports?

Timeline
3 months
Platform
Web Application
The Brilliant Team
→ Antoinette Read — Product Manger
→ Luciano Dantas — Principal Engineer
→ Jennie Morton — Principal Technical Writer
Role & Responsibilities
→ Design Lead
→ UX Research
→ Design System Contribution
→ Partnered with PM to define product requirements.
 
 

Business Outcome

Achieved a ↑ 30% increase in adoption among financial customers, and a ↑ 20% growth in recurring Discovery Board views.


System-level Impact

The filtering pattern was later adopted by Workday’s central design team and reused across broader areas, including process workflows and conditional logic.


 
 
 
 
 

Discovery

 

To expand on this, this was the original state of Discovery Boards, where filters only supported "AND" conditions (click). For example, users could filter by hire date in 2019 and California location, but not by hire date in 2019 or California. This was especially challenging for financial users with complex needs or use cases, often forcing them to export data or avoid the tool altogether. It also slowed performance when running the report due to large, unfiltered data sets.

 
 
 

Business Value

  • Unlocks Complex Financial Use Cases

  • Reduced Data Exports and Workarounds

  • Improved Performance and Query Efficiency

 
 
 
 

 

Design Approach

  • Existing Alternative Analysis
    I started by reviewing existing Workday solutions and found nested filtering only in Composite Reports tooling, but we chose not to reuse it. It was built on an older framework and had major usability issues, poor visual hierarchy, unclear logic with parentheses, and error-prone grouping—making it unsuitable for a scalable experience.

  • Competitive Analysis
    Next, I explored how other platforms like Notion, Airtable, Salesforce, Power BI, and SurveyMonkey handle nested filters. While they improve readability with visual grouping, indentation, and plain-language logic, they struggle with deep nesting—none support more than two levels, and the lack of collapsible groups makes the experience overwhelming.

  • Early Design Sketches
    I started with quick sketches to figure out how nested AND/OR filters should work. I realized they usually follow a hierarchy, with parent filters containing child conditions, and sometimes multiple parents. This helped me quickly understand the structure and flow.

  • Design Iterations and Testings
    I went through several rounds of early design iterations and narrowed it down to two options for internal user testing using a Compensation Grade filter scenario—like 'hired in 2019 and in California, OR hired in 2022 and in Alabama.

 
 
 
 
 
 

Design Iterations

The Advanced Filter went through many iterations before we had a shippable design candidate.

 
 
 
 
 
 
 

Final Design

 
 
 
 
MacBook Pro
Demo Content

First Top Level Filter Group

The user adds a filter from the Sheet or Viz area, selects a field and value, then chooses AND, OR, or starts a nested group. Selecting AND reveals options like nested OR or a new OR group. The design provides flexibility to build and adjust logic on the fly, including switching between AND and OR at any level.

 
 
 
 
 
 
 

Add A Nested Group


Next, the user creates a nested filter by clicking (click) 'Add Nested Group (OR)' to create a second-level group within Group 1. After input, the filter switches to view mode. Each group is numbered and titled for easy scanning and quick understanding of the logic structure.

 
 
 
 
MacBook Pro
Demo Content
 

 

 
 
 
 
MacBook Pro
Demo Content

4 level of Nested Groups

This example shows a four-level nested filter. Based on user feedback and use cases, we capped nesting at four levels to prevent overwhelming the UI. At the limit, the add button is disabled and a tooltip explains the max depth.

 
 
 
 
 

Add Second Top Level Filter


This shows a second filter group, clearly labeled for easy tracking. The panel is also wider, and users can expand it manually or fully expand it via the overflow menu to better manage complex filter logic.

MacBook Pro
Demo Content
 
 
 
 
 
 

DESIGN MICRO INTERACTIONS

And finally, here are some micro-interactions that enhance usability. Users can collapse filter groups for a quick overview of the logic structure without visual clutter. They can also reorder individual filters within a group—something that came directly from user feedback and supports more flexible filter management.

 
Before
Drag & Drop Interaction
After
Expand & Collapse Filters Interaction
 
 
 
 
plain-color.png