idea Sort Table Attribute Dynamic Text based on Symbology order in ArcGIS Pro Ideas

Sort Table Attribute Dynamic Text based on Symbology order

HansRasmussen — Mon, 09 Aug 2021 22:25:57 GMT

Table Attribute Dynamic text sorted as per the Symbology Order and legend, specifically I'd like to be able to show the area of a polygon besides its legend patch dynamically. Currently the attributes look to be sorted by objectid.

Re: Sort Table Attribute Dynamic Text based on Symbology order

AubriOtis — Mon, 09 Aug 2021 22:53:52 GMT

I'm not sure what you are looking for here. You can add a different text element for each layer and place it near the legend. Are you trying to add them all as a single piece of text?

Re: Sort Table Attribute Dynamic Text based on Symbology order - Status changed to: Needs Clarification

AubriOtis — Mon, 09 Aug 2021 22:54:04 GMT

Re: Sort Table Attribute Dynamic Text based on Symbology order

HansRasmussen — Mon, 09 Aug 2021 23:11:45 GMT

See picture. In the layout, the legend item is the Timber Type. For a given area, there can be one or several Timber types. The legend is set to only show what is visible in the map. Currently for the Type Area, I have to manually type in the associated area. I would like to use dynamic text for this and sort the dynamic text for the Type Area to be the same as the Legend. I can use a function with Shape_Area to convert to hectares and round to one digit with Table Attribute Dynamic text, but it is not sorted the same.

Re: Sort Table Attribute Dynamic Text based on Symbology order - Status changed to: Open

AubriOtis — Tue, 07 Dec 2021 16:13:17 GMT

Add an "order by" option within the Insert Table Attribute dialog

CRose — Wed, 09 Mar 2022 22:56:12 GMT

When using Dynamic Text > Table Attribute, I would like to control the order of items using an attribute field of my choice. Currently, it is limited to ordering by the OBJECTID, which I can't easily modify.

I am using a geodatabase table to create a geologic map legend.

Re: Sort Table Attribute Dynamic Text based on Symbology order

LindaWilliams1 — Mon, 03 Apr 2023 19:52:30 GMT

My use case is road or bikeway types and total lengths within cities. I have a map series of all the cities in a county, and instead of showing both a legend and a separate dynamic table of types and miles within each city, I'd like to combine them to show a symbol patch, a type/class description and the total miles within the map series shape.

Re: Sort Table Attribute Dynamic Text based on Symbology order - Status changed to: Under Consideration

AubriOtis — Mon, 03 Apr 2023 20:04:54 GMT

Re: Sort Table Attribute Dynamic Text based on Symbology order - Status changed to: In Product Plan

AubriOtis — Fri, 02 Jun 2023 22:38:10 GMT

Re: Sort Table Attribute Dynamic Text based on Symbology order - Status changed to: Implemented

AubriOtis — Wed, 15 Nov 2023 23:54:35 GMT

This Idea has been implemented in ArcGIS Pro 3.2.

Please see the What's New documentation for more new features in Pro 3.2.

Re: Sort Table Attribute Dynamic Text based on Symbology order

CRose — Thu, 16 Nov 2023 20:29:01 GMT

Thank you for bringing this functionality to ArcGIS Pro!

Re: Sort Table Attribute Dynamic Text based on Symbology order

CRose — Tue, 03 Dec 2024 21:35:31 GMT

@AubriOtis is there a limit on what type of field can be used to Sort? My dialog is not offering any field names in that dropdown.

Also, it's worth noting that when using an SDE, the order seems to be based on GlobalID, and that is constantly changing as data gets updated... so the order of items in my dynamic text is now changing all the time.

Edit to add image:

Re: Sort Table Attribute Dynamic Text based on Symbology order

AubriOtis — Tue, 03 Dec 2024 21:47:24 GMT

@CRose that's interesting. It can sort by text or numeric fields. Blobs don't work, and I don't think date fields are supported (but I may be misremembering). What other field types are in your table? How many fields are you expecting to see?

Re: Sort Table Attribute Dynamic Text based on Symbology order

CRose — Tue, 03 Dec 2024 21:54:23 GMT

I had created a "Short" (integer) type field called "LegendOrder" to use for this purpose, but it doesn't appear in the sort dropdown. None of my twelve text fields appear in the Sort dropdown either.

Re: Sort Table Attribute Dynamic Text based on Symbology order

AubriOtis — Tue, 03 Dec 2024 22:41:37 GMT

Ah, I see what's happening. Your field is an expression. When you are returning an expression instead of a field the values might not match the values in the table. The potential for mismatch means a field can't be used. You can sort by the expression, but that's all.

Re: Sort Table Attribute Dynamic Text based on Symbology order

CRose — Wed, 04 Dec 2024 16:31:56 GMT

Ah, ok.

I expected the Sort option to be independent of the "Field" that is displayed.

My field expression in this case is just a concatenation of my "delimiterBefore" (usually but not always a new line) and my "legendText" attributes. I this case I may be able to restructure my table rows to use the delimiter in this dialogue instead.

I do think it's pretty confusing for the default sort order to be based on the GlobalID, which changes every time a row is edited.