AnsweredAssumed Answered

Help with stacked bar chart

Question asked by jpbarna on Jan 28, 2018
Latest reply on Jan 29, 2018 by jbrown

Hi, I feel dumb failing to do this but I don't have experience with FMP Charts

 

I have a table of people and events, like this

 

Person A, Event A

Person B, Event A

Person C, Event B

Person B, Event C

Person A, Event C

Person C, Event A

Person B, Event B

 

I just need to graph the Persons in the X Axis and the number of events of each type in a stacked column, for each person.

 

Can this be so hard?

 

In my previous example, my Person A bar would be

 

Event A: Value 1

Event B: Value 0

Event C: Value 1

 

Sorry but I think I must use summary field to count the Event Types for each one but I'm not sure. Doing a report by person and event is really easy so, why can't I just graph with that simplicity?

 

I'd love a little help with this,

 

Thanks

 

JP

Outcomes