Expand Summary operations to include Min or Max Dates and fgdb Subqueries

RichardFairhurst — Thu, 25 Feb 2021 16:17:30 GMT

Currently all summary tools in ArcMap, like Summarize from a tableview, Summary Statistics, Frequency, Dissolve, Spatial Join, etc., do not work to summarize dates for Min or Max values. Dates can only provide a first and last in the Summarize output from tableviews, but they can't even do that from Summary Statistics or Frequency. Many operations are based on finding the oldest or most recent or next date within a set of records in a table and having no way to effectively find this in ArcMap is very frustrating.

Dates can't be the unique value field for the Summarize operation in a tableview, but they can be for the Summary Statistics, Frequency and Dissolve operations. Why does Summarize support the exact opposite options relative to Summary Statistics, Frequency and Dissolve for dates/ Why don't they all support using dates as unique values, and at least first and last summaries (although Min and Max is far more useful)?

Personal geodatabases and SDE databases support such date summaries in their subqueries, but fgdb's do not not. Those other databases can also perform subqueries within the table where selections are being made based on the subquery result, but not fgdb's. I nearly always want to select the set of recrods for the max date of the set of unique IDs within the same table, not an external table.

The closest work around for an fgdb I have come up with is listed in this post:
http://forums.arcgis.com/threads/89570-Select-By-Attributes-latest-date-from-Data-Table?highlight=max+date
However, the number of steps is far too many to use for on the fly analysis.

Please devote more effort to making summarizing and uniquely grouping data on date fields more accessible and easy.

Re: Expand Summary operations to include Min or Max Dates and fgdb Subqueries - Status changed to: Closed

MargaretCrawford — Tue, 07 Mar 2023 22:35:18 GMT

Regarding the first point, ArcGIS Pro tools like Summary Statistics do support statistical operations like Mean with a Date field. File geodatabases continue to not support sub queries.

It looks like you’ve included multiple ideas in this request, which doesn’t adhere to our Submission Guidelines. If you would like to have continued discussion around the enhancements you proposed, please open them as new individual ideas.

Thank you!

https://community.esri.com/t5/community-help-documents/arcgis-ideas-submission-guidelines-and-statuses/ta-p/904874

Re: Expand Summary operations to include Min or Max Dates and fgdb Subqueries

Bud — Tue, 07 Mar 2023 22:38:54 GMT

idea Expand Summary operations to include Min or Max Dates and fgdb Subqueries in ArcGIS Pro Ideas

Expand Summary operations to include Min or Max Dates and fgdb Subqueries

Re: Expand Summary operations to include Min or Max Dates and fgdb Subqueries - Status changed to: Closed

Re: Expand Summary operations to include Min or Max Dates and fgdb Subqueries