AnsweredAssumed Answered

Filtering Dashboard with Related Table

Question asked by cypherja on Nov 20, 2018
Latest reply on Nov 21, 2018 by jschwartz@fcgov.com_fcgov

I have a point feature, with a related table storing data...

 

How can I add filters to a Portal Dashboard, so that the point features on a map are filtered based on their related table data?

 

For instance, I have a point to show the location of a gas leak.  A related table record is added during the investigation, and a 'leak severity class' is added in the related table.  How would I add a filter to the dashboard to show all points that have a leak severity class of "Grade A"?

 

Since the point doesn't have this leak grade attribute information, I'm not sure how make the filter work, since there is no "leak severity class" attribute in the point feature for me to set as the target.

 

I can't do a join, since it's a one to many relationship (one point could have multiple inspections).

Outcomes