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,