Checkbox element

[peterpetrov]

Hello,

I have a form that i set checkboxes as options. There are 7 checkboxes for each day of the week. Since they are submitting multiple selections in the database it goes as:

["2","3","5"]
["2","4","6"]
["3","4"]
...etc.

I am looking for an advice how can i extract some sort of statistics on which day is more popular. For example 2 is Tuesday and i would like to count how many Tuesdays are set in the database?

Regards
Peter

 

[cheesegrits]

The best way to do it would be to use a checkbox join instead of a checkbox element, with your options as a simple lookup table you create a list for. Then you'll have a many-to-many table, which Fabrik creates automatically, with one row per check, linking parent to selection, and you can do whatever reporting you need on that.

Other than that, some relatively simple custom code which runs a database query would be required to do your counts, using something like Sourcerer to embed the code in an article, or putting it in a custom template.

-- hugh