Say for example you have a document with two or more embedded views. Those views share a database.
And you want to filter those views based on some user-defined arbitrary value(s).
Is this possible in the current implementation of documents and filters?
e.g., you could have a document that has a running summary of tickets in a software development team, and apply “where ticket.type = bug” filter which revises the total to be filtered to bugs only, and the list view to show only bugs
It isn’t possible to apply filters to embedded views.
However, if you use a db with a rich text field to store your documents, you can apply context filters to views embedded views (but one at a time).
Overall, it sounds like your use case
sounds like it would be best solved by just configuring the collection field of Issues on the Team entity view, so that there is a relation view for ‘bugs-only’.
This is fine for the provided example and will work with defined and discrete options.
What if I wanted to allow users to drill-down into any entity and show a dashboard related to that entity? For example, they could group the data by project and get a summary of moving parts, deliverables, analytics etc. from a single document?
Have you considered creating an entity view - with the relevant collection fields shown (and unnecessary fields hidden) - and for each collection field, you can choose the best relation view to display whatever you need.
That doesn’t let me embed charts, numbers, etc., and lay it out like a dashboard. There would be potentially multiple of the same link required just to get some sort of reporting to display, since each one of these would need to be a separate relationship to make them all display at once