Cascading Filters (AND/OR Logic) for Reports & Dashboards

Follow

Kennard Ruslim

• 13 February 2025 08:24

Hi everyone,

Currently, aXcelerate’s filtering system is limited in how we can apply multiple parameters. Currently, while AND logic works, it doesn’t work when applying multiple values to the same parameter, and there is currently no OR logic available.

I reached out to aXcelerate support about the filtering limitations in reports, and they suggested creating multiple reports as a workaround. However, this isn’t a great solution for those of us using reports for dashboards—having multiple reports means multiple dashboards, making it harder to manage data efficiently.

If aXcelerate introduced OR logic and allowed multiple conditions within the same parameter, reporting and dashboards would be much more efficient. Has anyone else faced this issue? Hoping aXcelerate can consider this improvement!

4

• 

  Pip Austin

  • 13 February 2025 22:50

  Absolutely this would be useful!

  1

  Comment actions Permalink
• 

  Kennard Ruslim

  • 17 February 2025 00:42

  Thanks for your comment, Pip.

  Another useful feature would be the ability to filter using options like “include,” “exclude,” “blank,” “is not blank,” etc.

  

  1

  Comment actions Permalink
• 

  Myrthe Wildeboer

  • 22 September 2026 04:30

  Great idea, Kennard! I would love the addition of AND/OR logic in the Report Builder. This would make reporting more efficient, reduce manual work, and provide greater flexibility when creating targeted reports.

   

  An example:

  Currently, when I need to identify candidates who answered "Yes" to multiple enrolment form questions, I have to create separate reports for each question and then manually compare the results. For example, I need one report for candidates who answered "Yes" to Question 1 and another report for candidates who answered "Yes" to Question 2.

  With AND/OR logic, these conditions could be combined into a single report, such as:

  • Question 1 = Yes AND Question 2 = Yes
  • Question 1 = Yes OR Question 2 = Yes

   

  0

  Comment actions Permalink

Please sign in to leave a comment.