Advanced custom filter logic & global dashboard filters

Feature Requests
,
2

Hi Aline,

Thank you for your thoughtful suggestions and for sharing your use cases in detail!

1. Dashboard-level global filters

The good news is that eazyBI already supports this! You can use common page filters to apply a single filter across all reports on a dashboard simultaneously.

Here is how to set it up:

  1. Open your dashboard in edit mode and make sure reports are expanded
  2. Click on the page dimension filter (e.g., Team or Sprint) in one of the reports
  3. Select “common page” — the filter will move to the top of the dashboard
  4. Save the dashboard — from now on, selecting a value there will apply to all compatible reports at once

You can also enable “Hide common dimensions” to hide the filter from individual reports since it is already handled at the dashboard level.

Please note that the common dashboard filter will influence only those dashboard reports that have the same dimension in page filters.

See Create dashboards documentation

2. Advanced / Smart custom filter logic (Sprint grouping across projects)

For your sprint use case — grouping sprints with the same name across multiple projects — there are a couple of approaches in eazyBI:

  • Calculated members: You can create a calculated member in the dimension that aggregates all members matching a specific name pattern (e.g., “Sprint X”) using an MDX formula with the Filter function and name matching. This way, selecting that single calculated member would combine data from all matching members across projects.
    For example, a calculated member using Filter and MATCHES for Sprints could look like this:
Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentHierarchyMember.Name MATCHES 'Sprint X'
  )
)

I hope this helps address your needs!
Please feel free to reach out if you have any further questions or need help setting up these solutions.

Best,
Ilze (eazyBI support team)