filter_box being filtered by other filter_box: hierarchical dimensions and dependent dimensions

[Carsten Steckel]

Dear all,

I have a table in postgres with the columns DIM_A1, DIM_A2, DIM_B, DIM_C, METRIC_1, METRIC_2, ... DIM_A1 and DIM_A2 are hierachical (e.g. department->group, country->state->city). Not all theoratical combinations of dimensions are in existing. e.g. DIM_B has values A,B,C and DIM_C has values 1,2,3. only the tuples (A,1),(A,2),(B,2),(B,3) are really existing in the data.

I added a filter_box with DIM_A1, DIM_A2 and a filter_box with DIM_B and a filter_box with DIM_C to a dashboard. A pivottable on the same dashboard reacts perfectly to filtering in one of the boxes. 

Here my help/feature request:

1) If I filter a DIM all other filters will need to reduce there possible values down to what ever is possible under that first filter. e.g. if DIM_B=A the drop down of DIM_C is only populated with 1,2

2) If I filter a hierarchical DIM (e.g. DIM_A) the dependent drop downs in the same filter_box are populated with only the values availble under the previously selected higher hierarchy.

Is it doable by configuration and I was only to unexpierences?

How do I write my own visualization and extend the filter_box? Is there a tutorial or howto?

Cheers and many thanks

Carsten

[Maxime Beauchemin]

I'm not sure if you have discovered this entry in the FAQ:

http://airbnb.io/caravel/faq.html#how-to-add-dynamic-filters-to-a-dashboard

Currently, filtering on one field won't refresh the other fields within that same filter box. Other filter boxes will be reloaded with the filter applied by default.

For "cascading" filters, you usually want that flow to be directional, and you'll have to use multiple filter boxes for that to use. You probably want to use the `filter_immune_slices ` configuration in the json to set the 1st filter box to be immune to filters. 

Let us know if the docs are clear enough and if this satisfies your use case.

Max