How Do I Apply different filters to same data on multiple Experience Builder pages

[SunniBoulton]

Dear Community

I have an Experience with

- multiple pages, each page showing a different geographic extent (I have 5 pages to set up)

- one data set, that is used throughout the multiple pages

- a List on each page, aiming to display attributes from the dataset that have been filtered to this geographic extent. 

My data has a field called "Map Extent" that relates to each of the 5 pages (They are Port Macquarie, North Shore, Wauchope etc).  I need each Page to return attributes (from this one data set) unique to that geographic area.

The problem is this:

On each page, I bring in a new Filter Widget and create an automatic filter, based on the map Extent attribute (e.g. "Map Extent" IS "North Shore")

When I set just one page, it works perfectly, the List widget returning results that are unique to that map extent (see attachment North Shore Page 1).

However, when I bring in a new Filter Widget and set it up for a second map extent /page, gives me a "No Data" message (see attachment Wauchope Page 2). It seems the first filter carries through to the other page and affects the results. 

How can I set a unique filter for each page, so it doesn't affect all the other pages?

[JeffreyThompson2 · Accepted solution]

This is what Data Views are for. Data Views are independent slices of your total dataset. You should set up a Data View for each page of your application. 

Click the stacked circles on the left of the screen to open the Data Sidebar. Then click on your data and go to Create A View. 

Create a SQL query with all of your data. OBJECTID is not blank will work. You'll probably want to give each View a distinct name to match what page they are used on. You can click the pencil in the header to rename. Repeat and make a Data View for each page.

When selecting data for a widget use the dropdown menu to find the correct Data View. (You can also set up your Data Views from this menu.)

Each page should now act independently.

[SunniBoulton]

Ok, great, thanks so much for your help!

[JenniferBorlick]

I'm trying to do a similar thing, but I want the user to be able to pick from a list. I have a filter with a list set up on the map and I want the same filter set up on the splash screen. When the splash screen is open and I use the filter, I can see the map navigate to the correct place. Then, when I continue to map, the map goes back to the initial extent. Here is the app I created (without the filter on the splash screen but it is in the map.) Is there a way to get it to "stick?" I know it works for searching, but I would like the user to be able to zoom to all the zoning parcels in a town and only see those parcels.

Another thing I would like to do is to have the zoning overlay layer only draw for the selected town as well. The list I created filters based on the prefix in the zoning code. If the prefix is 002 it filters the zoning parcels in the Town of Avon, etc.

Am I asking too much, or just not thinking of all of the available tools?