<p dir="auto">Hi,<br>
is it possible to have a filterbox with mutiple filters whose filter options are dependant on the already selected entries?</p>
<p dir="auto">Let's say we have the following table "sold_products":</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="customer  | product | product_category | revenue
----------+---------+------------------+-----------
alice     | teddy   | toys             | 20
alice     | doll    | toys             | 10
alice     | skirt   | clothes          | 25
bob       | car     | toys             | 15
bob       | holmes  | books            | 10"><pre class="notranslate"><code class="notranslate">customer  | product | product_category | revenue
----------+---------+------------------+-----------
alice     | teddy   | toys             | 20
alice     | doll    | toys             | 10
alice     | skirt   | clothes          | 25
bob       | car     | toys             | 15
bob       | holmes  | books            | 10
</code></pre></div>
<p dir="auto">Then I create a Filter Box with</p>
<ul dir="auto">
<li>customer</li>
<li>product</li>
<li>product_category</li>
</ul>
<p dir="auto">I would like to achieve the following:</p>
<ul dir="auto">
<li>When I select "customer" filter = "alice" products filter just shows ["teddy", "doll", "skirt"]</li>
<li>When I select "product_category" filter ="toys" products filter just shows ["teddy", "doll", "car"]</li>
<li>When I select "cutomser" filter ="alice" AND "product_category" filter ="toys" products filter just shows ["teddy", "doll"]</li>
</ul>
<p dir="auto">Currently all values are always shown. Is there a way to achieve the behaviour described?<br>
I know this will cause some  DB stress, which is acceptable. Thanks!</p>
<p dir="auto">When you are filtering by more than one element, the values chosen in previous filters should limit the choices in subsequent drop downs<br>
Consider the Country - State - City example....or any hierarchy of values really.</p>
<p dir="auto">I would like to have filters applied in sequence, so that if I choose 'USA' from my country filter, I only get options relevant within USA. Then if I choose 'Ohio' from my state drop down, I would only get cities in OH from my 'City' drop down.</p>
<p dir="auto">We can create multiple filters that apply to each other but the visual is bad...the filters take up way too much room on the screen.</p>
<p dir="auto">I know this has been proposed before ( <a href="https://github.com/apache/incubator-superset/pull/5664" data-hovercard-type="pull_request" data-hovercard-url="/apache/superset/pull/5664/hovercard">5664</a> ) but seems like it was shelved dues to some other filtering changes coming, what happened to that?</p>