nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Count of one field based on another field in charts

RachelS

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.

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

Find more posts tagged with

Accepted answers

jcarlson

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

All comments

jcarlson

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

RachelS

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.

jcarlson

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

RachelS

I just see that, thank a million.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.