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).