ExB Enterprise, 11.1
I have two charts using the same data, but configured for different fields. The first breaks down Permit Type, the second breaks down Permit Status.
When I click on a piece of the first chart, the map filters and selects to only records of the type selected. Selecting a piece on the second chart results in what we want: the map further selects down so only features of the selected type and selected status display on the map. It seems to be using an AND select on the back end, which is desired.
The Table widget is setup to Filter Data Records when the Map selection changes. So I would expect it to select only the records that are selected in the Map. But it doesn't. It shows all of the features selected by charts; like it's using an OR clause where the Map uses an AND clause.
How can I get the Table Widget to perform like the Map?