Is it possible to summarize field values with dynamic text in a layout?

Marie-JoëlleDesgagné

Hi!

Here is what i'm trying to do:

I have a layout showing different types of plants. What I would like to do is to make a summarize so we know how many plants we need to buy from each kind. So far, I only have been able to show a list of the attributes with a table frame:

What I would like to se is something like this:

So there is 3 main categories and many of subtypes. I would like to see how many type of each is showing on the map. 

Thank you !!

 

TomBole

Hi Marie-Joëlle, 

Have you looked at Table Dynamic Text?  You should be able to use the Custom query option to define the category and subset for each text item.

You can access a number of table statistics from the Dynamic Text gallery.

Once you've clicked the statistic that you want you will get a dialog where you can choose the query type.

Choosing Custom query will give you a button "New expression". 

Click "New expression" and you should see the expression builder. Use this to build your expression. 

Using Custom query will a set a "static" query and will not adjust a result based on what features are in the map view - that is, "summarize the visible features in my map for these subgroups within this category".  In order to have a custom query and a spatial query active on the text element you would need to write some code using ArcPy.mp (python).  Here are some samples you find interesting. The Thematic Map Series sample may provide some helpful - even though you may not be interested in a map series, the sample may provide ideas on how to use ArcPy.mp to set temporary queries on layers.

Hope this helps, 

Tom