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

M_M

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

jcarlson

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.