Count of one field based on another field in charts

385
4
Jump to solution
03-23-2022 07:46 AM
RachelS
Occasional Contributor III

Hi,

How do I create a chart showing a count of one field based on another field.

For example below I have salmon appearing 3 times with the total count of 5. I'd like the chart to show Salmon 5, Pike 4, Rudd 10, Perch 3 etc. rather than just counting the species field.

fish.PNG

 If I use Grouped Values it only lets me select the Species and the number of times they appear rather than the number of fish field.

Thanks

Rachel

0 Kudos
1 Solution

Accepted Solutions
jcarlson
MVP Esteemed Contributor

In your chart settings, simply change the Statistic to being Sum, and point it to the field No. of fish.

jcarlson_0-1648048286227.png

jcarlson_1-1648048328908.png

 

 

 

- Josh Carlson
Kendall County GIS

View solution in original post

0 Kudos
4 Replies
jcarlson
MVP Esteemed Contributor

In your chart settings, simply change the Statistic to being Sum, and point it to the field No. of fish.

jcarlson_0-1648048286227.png

jcarlson_1-1648048328908.png

 

 

 

- Josh Carlson
Kendall County GIS
0 Kudos
RachelS
Occasional Contributor III

Thanks Josh,

 

I knew it was in there somewhere. I was trying to get it under pie charts.

That's me sorted.

Many thanks for the help.

 

0 Kudos
jcarlson
MVP Esteemed Contributor

Oh, those same settings apply to pie charts, too!

jcarlson_0-1648055458358.png

 

- Josh Carlson
Kendall County GIS
0 Kudos
RachelS
Occasional Contributor III

I just see that, thank a million.

0 Kudos