narrow list of items in filters used in reports

What is the challenge?

when creating a report that exposes filters, consumers find it difficult to use as the filter dropdown shows everything for the entire account instead of the list of items represented in the report.

What is the impact?

we have to create multiple reports that are very specific as the filtering dropdowns are unusable for a broad audience.

Describe your idea

for example if i have a report for that i have published to a web page that is focused on a single workspace and include a filter for release name i only want the dropdown to show the releases for that workspace and not every workspace in the account.