How to incorporate 2 columns in one data series

387
2
Jump to solution
05-24-2021 09:12 AM
RachelScott
Occasional Contributor III

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

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
DavidPike
MVP Frequent Contributor

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

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

View solution in original post

2 Replies
DavidPike
MVP Frequent Contributor

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

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

RachelScott
Occasional Contributor III

That's it!

Thank you so much.

Rachel