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,