Jump to content

Charts from value list


beckham
 Share

This topic is 2234 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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".

Link to comment
Share on other sites

This topic is 2234 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.