beckham Posted May 16, 2016 Posted May 16, 2016 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
comment Posted May 16, 2016 Posted May 16, 2016 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".
Recommended Posts
This topic is 3370 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now