Filter interaction wiping out second filter on same field

#1

Here is my situation:

I have two tables, Main and Detail.
I have three page filters that the user can select to narrow data,
Country, State, City, with corresponding view parameters, vpCountry, vpState, and vpCity.
These view parameters are set to apply to both the Main and Detail tables.

The Main table has Country, State and City as row headers with # of Lines as a measure.

Clicking on a row in this table will pop up another table with detail records and apply the filters. I don’t want the page filters to change though so I created three other view parameters that apply only to the detail table: vpDetailCountry, vpDetailState and vpDetailCity. The filter interaction sets these three Detail view parameters.

If I set the page filter City to New York City, the main table correctly shows United States > New York > New York City and if I click on the row next to New York City, the detail table is filtered correctly. However, if I click on the Grand Total row or the Total New York row, the detail table will show me all records, even though the page filter for City is still set to New York City and is applied to the Detail table.

I am assuming the filter interaction is somehow overwriting the page filter because the two view parameters are tied to the same field. Is there another way I should be handling this situation?

Thanks.

#2

That’s correct. If you have multiple sources which are filtering the same visualization, the most recent filtering action taken (whether that is selecting a value through a filter control or using a filter interaction on another visualization) will always overwrite the previous one. The same can be observed in reverse - if you set the filter control, any filtering done to that detail table via the filter interaction will be overwritten.

1 Like