Pie Chart With Collection of Records
I've never used the charts feature in Filemaker before (since it's a new feature and all), so I'm a wee bit stuck with this one.
I want to make a pie chart that give me a display of how many deals in a found set were won / lost. The data currently is simply a feild that states either "won" or "lost".
Currently Filemaker shows me a chart with one slice of the pie for each record, so I have slices all over the show, even though most of them are the same.
How do I get Filemaker to collect up the records and work out a logical chart?