topic Re: Return a GroupedBy result AND additional fields not in GroupedBy expression? in ArcGIS Dashboards Questions

Return a GroupedBy result AND additional fields not in GroupedBy expression?

M_M — Fri, 10 Mar 2023 17:06:29 GMT

Hello,

I would like to add a table to my Dashboard containing a bunch of GroupedBy results. However, I'd also like to have some fields in the table that are not currently in the GroupedBy expression. I guess they could be added to the GroupedBy and still make sense, but I don't have a Statistic for them as it would be 'username' and 'date' etc., and I don't know how to write them into the grouped by without a statistic.

Also, once the table is added to Dashboard, is it possible to assign an Action to zoom to feature in map when a row is selected in the table?

Data is being grouped by a polygon name (Stand#)
The only thing I could come up with was mess with the Actions on the table and a Category Selector created to filter by Stand#. Select row on table then go to filtered Category selector where it will zoom to map. Not very efficient. 🙂

Thank you!!!

Melissa

Re: Return a GroupedBy result AND additional fields not in GroupedBy expression?

ZenMasterZeke — Fri, 10 Mar 2023 17:23:29 GMT

I don't believe you can have an expression where some fields are grouped and others are not. I know you can't do this in SQL. The underlying set theory doesn't make it possible. All fields have to be aggregated in some way. Since the Group By returns a single result per field, it doesn't make sense to then also have a field(s) that contain multiple values.

You can (potentially) perform aggregation on fields within a record in the SELECT clause, e.g. averaging the sum of three numeric fields, and include other fields, but not across records.

Re: Return a GroupedBy result AND additional fields not in GroupedBy expression?

jcarlson — Fri, 10 Mar 2023 17:49:22 GMT

You can kind of do this. By adding your extra fields to the "groupby fields" parameter, you'll get your data grouped per stand / user / date combination.

GroupBy( your_featureset, ['Stand_number', 'username', 'date_field'], [{your statistic expressions}] )

To retain geometry, though, that can't be done unless you use a loop.