[…] 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.
Is FileMaker's charting capable of doing this? Any direction would be greatly appreciated.
Absolutely – if by this you mean charting summarized values.
Having said that, it isn't really possible with your current data structure. – Well, it is, but only if you create one summary and one calculation field for each value of the checkbox value list, which is really messy and would require constant maintenance.
In short, your data structure is not sufficiently normalized to allow this kind of analysis. (As in: “one field, one fact”.)
I suggest you do what you suspected all along would be a better way: create a table where each record represents a checked value. Now all you need for your chart is a summary field and a sort order.
You still can present the actual creation/deletion of a related record as the act of checking/unchecking a box, if your manager's heart is set on it.
I figured that would be the answer. I was against the checkbox set from the beginning but ultimately have to listen to who signs my paycheck lol. Perhaps knowing I cant report on what they want will help my case.
1 of 1 people found this helpful
If your customer / manager / person with power is dead set on having the checkbox set, you can also write a script that assembles the data into variables and chart that instead.
But really, try to get a proper data model in place if you can.