Need help representing related table data on an online map (dashboards or experience)

Question

Hello, I am trying to represent our water quality sampling data using a feature layer with a related table. The feature layer simply holds the sampling point, while the related table holds all the information taken each sampling time. Here is the webmap for reference: Buffalo Niagara Waterkeeper E Coli Sampling - Overview. At first, I attempted to create a visualization graph within the popup on the webmap with no luck (arcade expression is within the feature layer popup). Then I tried within dashboards, but I have no been able to figure out how to do it. Just a simple graph that shows E coli data over time, and filterable by sample station is all I am looking for. Any help is greatly appreciated.

LynnBerni · Answer

As you have discovered, options for accessing and displaying related data is often quite frustrating.

Per the suggestions from MobiusSnake, you will need to add a Map Element (with a map that includes your point data and the related tables), as well as the Chart Element to access and display the related data. But you don't set up the filters in the Map Element, rather the only way I found was with "Category Selectors" in either the Sidebar or Header elements.  You then use the Selectors to filter the charts by sampling location. And yes, lots of "polishing" and fiddling with the settings to get the dashboard working how you want.  One thing that is the most frustrating about related data in dashboards is that you cannot simply click on the sample points in the map to filter the data charts!

Here's my stream sampling dashboard, which is very similar to what you describe: Salt Lake County Stream Water Quality Dashboard.

p.s. don't forget to add and setup a Mobile View for your dashboard too :^)

MobiusSnake · Answer

FYI, your webmap isn't publicly available.

Typically what you'd want to do in a dashboard is something like this:

* Add a Map element to the dashboard, containing your webmap.
* Add a Chart element based on your related table.  For now it'll contain all of your related data, so it's not very useful.
* Open the Map element's configuration, and in the Layer Actions section go to your sampling point layer and create a filter.  You'll need to link the key from that point layer to the key in your sample table layer, this is usually using a Global ID field in the layer and a GUID field in the table, but not always.  You'll want to check the "Enable Only When Rendered" checkbox so the chart only displays data when a selection has been made.

Probably a lot of polishing to do after that, particularly getting the chart how you want, but that should get you rolling.