Reduce Assignee dropdown in pages to relevant users for the report

Hi everyone,

I have the following risk matrix:

I want to be able to filter for assignees (and reporters) of the chances and risks. Is there any way to reduce the Pages-dropdown of “All Assignees” and “All Reporters” to values that are available in the report?

At the moment all users are shown in the dropdown. My goal is, that only users are shown that have at least one item in the matrix they are responsible for. That way it would be much easier to filter for relevant issues.

Thanks for your help!
Martin

Hi everyone,

does anyone have an idea how we could realize this?

Thank you very much!
Best regards

Hi @MZH,

You might enable the Nonempty on pages.


Please read more about that here - report Pages.

That will check the previously selected dimension members and drop the remaining members with no value for the measures. However, if the dimension members have historical values for the dimension combinations - they might still be retained.

Regards,
Oskars / support@eazyBI.com