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.