I'm pretty new to Metabase. I'm building a simple line chart which has two filters - "Borrower" and "Covenant". This chart will be meaningless if BOTH of these are not selected. There are three things I want to do and I can't work out how to:
- Borrowers have certain Covenants associated with them. When I select a Borrower, I'd like the Covenant pulldown to be restricted to only Covenants associated with this borrower
- Until BOTH Borrower and Covenant are selected, I don't want the chart to be visible. This could be a large text bar across the chart warning users to ignore and that text bar is n longer visible when both are selected
- I want there to be a title on the chart which dynamically shows the Borrower and Covenant on the chart
Thanks in advance