AnsweredAssumed Answered

Charting a specific dataset

Question asked by MattLeach on May 11, 2016
Latest reply on May 11, 2016 by Mike_Mitchell

I've never made much use of FileMaker's charting capabilities but am finding myself in need of creating a few charts but I'm not certain how to proceed.

 

I have a table that contains notes for our client's records. There is a field within this table called Type. This field on the layout contains a checkbox set where multiple values can be selected. There are probably about 50 choices. I know there are better ways to accomplish this without using the checkbox set but this is how the managers prefer.

 

What I am attempting to do is create a chart that I can filter by day / week / month, etc.... that will show me the total count of each type based on the filter I select, but only to include those types which have been used.

 

I setup a chart utilizing the Type field in the Y axis and a Count (type ) in X but it was just a mess.

 

Is FileMaker's charting capable of doing this? Any direction would be greatly appreciated.

Outcomes