Can you use a Data Expression to reference a layer filtered by a Category Selector?

ZachLansford_HD — Thu, 09 Mar 2023 18:43:02 GMT

Is it possible to set up a Data Expression to reference a layer within the dashboard that is being filter by a Category Selector?

I have a dataset that is comprised of a point layer and a related table. The point layer represents a summary of a days work in the field with a particular piece of equipment - ex metal detector, backhoe, etc covering x area in y hours. There is a one to many relationship set up with a table that contains specifics about what possible items are being found in the field, with several fields categorizing the items as well as number of items found.

I have set up a dashboard with some Category Selectors that apply to the spatial point layer. Is there a way to set up a Data Expression where the filtered spatial layer also filters the indicators that are referencing the related table?

Re: Can you use a Data Expression to reference a layer filtered by a Category Selector?

ZachLansford_HD — Thu, 09 Mar 2023 20:28:36 GMT

I believe I have found a solution, although it is a little cumbersome. I constructed a Data Expression that joins the fields I am filtering by (equipment name, region, operator) in the point layer to the relevant data I need from the related table. Now I can use the source and target field functions in the Selector since I have matching fields between the two datasets.

topic Re: Can you use a Data Expression to reference a layer filtered by a Category Selector? in ArcGIS Dashboards Questions

Can you use a Data Expression to reference a layer filtered by a Category Selector?

Re: Can you use a Data Expression to reference a layer filtered by a Category Selector?