Hi can anyone point me in the right direction, I have a database that as a Field populated by a value list, i.e.,: Christmas,Easter,Mothers Day , etc. I want to chart how many records exist of each chosen category. I thought it would be from a summary field using Total of and count but that option isn't available, How do I get filemaker to count the number of uses of the word Christmas from that field , can anyone help please?

Thanks in advance

5 minutes ago, beckham said:

but that option isn't available,

What do you mean by that?

 

5 minutes ago, beckham said:

How do I get filemaker to count the number of uses of the word Christmas from that field ,

You use a summary field, defined as count of [any field that cannot be empty]. And - this is the important part - you sort your records by the category field.

• In a report, a summary field placed in a sub-summary (by Category) part will display the sub-summary value for that category.

• In a chart, use the summary field as the Y axis value and set the chart to "Show data points for groups of records when sorted".