idea Pivot Table Chart Style in ArcGIS Pro in ArcGIS Pro Ideas

Pivot Table Chart Style in ArcGIS Pro

FPCWAGIS_Admin — Fri, 18 Dec 2020 17:06:44 GMT

In some map products I've been making, I'm required to include relatively simple statistics in the map legend (i.e. SUM of feature areas by Category). I've had a look at the Dynamic Text option which can SUM values for a field (almost does the trick), but as I'm using the Shape_Area value to get dynamic areas, they're recorded in square metres. I'm wanting to display the figures as Hecatares. In the Attribute tables, this is easy done using the Rate format with a value of 10,000, but this doesn't flow through to the Dynamic Text (still sums in m2). Instead I'm using the Bar Chart option to display the numbers, though really it doesn't need the "Chart" element, just the category and numbers (like in a pivot table). This method does honour the formatted values to show Hectares instead of m2.

Instead of this;

Display this;

Options could include colouring the columns as per the Category (like in the Bar Chart), having a Total Column on the end, wrapping the Category labels like in my image, number formatting, etc.

Re: Pivot Table Chart Style in ArcGIS Pro

LindsayRaabe_FPCWA — Thu, 18 Mar 2021 05:11:44 GMT

Can someone at ESRI tell us if anything like this is on the roadmap? Basic Pivot tables would make our life soooooo much easier!

Re: Pivot Table Chart Style in ArcGIS Pro

KoryKramer — Thu, 18 Mar 2021 12:19:10 GMT

It's not a chart style, but have you tried using the pivot table tool? https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/pivot-table.htm

Re: Pivot Table Chart Style in ArcGIS Pro

LindsayRaabe_FPCWA — Fri, 19 Mar 2021 00:11:42 GMT

Hi @KoryKramer I haven't tried that tool - we don't have an Advanced licence so won't work for us anyway. I'm really looking for a dynamic function here that would serve well in Map Series or dynamic map templates for non-gis staff to use (open - zoom to area - export sort of work flows).

Re: Pivot Table Chart Style in ArcGIS Pro

Bud — Tue, 05 Mar 2024 07:28:43 GMT

I would like to create dynamic pivot table layers using the UI in ArcGIS Pro.

Similar to Excel pivot tables.
The tool would produce a query layer.
Similar to pivoting data using SQL, but using the UI. Writing SQL pivot queries is time consuming and it’s very easy to make a mistake. Whereas Excel pivot tables are easy to use. And it’s pretty hard to make a mistake like accidentally omitting data or mishandling nulls.

Related: Pivot Charts

Re: Pivot Table Chart Style in ArcGIS Pro

Bud — Fri, 14 Jun 2024 20:36:01 GMT