How to incorporate 2 columns in one data series

[RachelS]

Hi,

I have a column for bird type and a column for the number of them seen.

So say there were 10 records of Cormorant but at each sighting there were 10 cormorants spotted. That would be 100 but for the serial chart it only allows me to add one Category Field.

What is the best way to display this data in operations dashboard?

Thanks

Rachel

[DavidPike · Accepted solution]

You should be able to use 'Grouped values' -> Category field = BirdType

then a 'Statistic' -> 'Sum' 'Field' = NumberSeen

[RachelS]

That's it!

Thank you so much.

Rachel