Report tool

This would be a great function. I look forward to seeing any progress you might make in this direction.

I'll add my voice to this request too. I'll start writing some simple forms that should work for what I need, but I'm new to php and it might take me a bit to get something working.

Here is some code that does some basic tally statistics on checkboxes and radio buttons.

I will post it here in case ullgren would like to use it and make it a patch or something.

It has co-opted one of his menu hooks and only handles checkboxes and radio buttons. It is not part of any official fork so I stress it is unsupported and try if you like.

It may not sit with his future design philosophy.

There are two files: webform.inc, webform.module
I will post the second in an immediately following post.

Here is the second file. The code is invoked from the "analyse" option from the webform menu.

If you like it and it's not duplicating work being done elsewhere, let me know and I will improve it a bit.

Having a look at it now I can see it could have perhaps percentages in place of tallies and maybe a little character based analog bar to give people faster relative proportions.

There is a tiny bug that was caused by a foreach throwing an exception on a zero length array. This occured if you did not tick any boxes in a group of checkboxes.

It is fixed in the attachment.

My error. It is fixed in this attachment.

Will do, I am travelling at the moment so I have no Unix tools.

I shall tidy the code, pull out the superflous commented code and make it a bit more efficient. There is a JOIN there that is not needed etc.. and I can see a couple of unnecessary range checks...

Are you happy for me to expand the analysis section in that format? I personally would prefer to see the reports done as a tab off the main page. ie, where it currently has sub-tabs on the main form page: /drupal/node/xx

"View Edit Outline"

I would like to add "Results"

Under this you would have a submenu with "submissions, analysis, tables, download, clear" etc... which would be for THAT forms submissions only. Permissions would be set so this results section is only viewable by appropriate persons, same as is done for "edit".

That way, the whole "Webform" menu option would dissappear, but if you liked you could have another "create content" option which would allow the adding of one or more tailored survey reports to the site. Again with appropriate permissions. One of these reports could be an "all webforms" which would list them all much as /drupal/webform does now.

I still think you could get down to two clicks if you attached the reporting node to the books outline. Then you would simply get there through the top menu "books".

My intuition is that the statistics etc on forms will rarely be of interest to everybody and so should not take up menu real-estate. When they are of most interest to people is when "they" have just done the form.

I'll do a bit of research, in the meantime, here is another cut. See what you think. Feel free to hack at your leisure. There are many areas I am sure I am un-drupal and I am not strong with PHP.

There is some cases where the output needs to be more theme controlled for better layout management and there are a few magic numbers scattered about.

A few improvements:

1. tidied the code, added doxygen comments, consolidated magic numbers etc..
2. added analysis support for textareas
3. improved results display; identified defaults, improved views

A few more improvements:

1. Ensured thematic control of major elements and added some subheadings etc
2. Some minor code based efficiency improvements
3. Added a Covariance Matrix for cross-correlating results

The Covariance Matrix

I added this to allow webforms administrators (ala me) to quickly identify cross relationships between user answers. The table should be read left to right. The column and row numbers corresponding to the (now labelled) options on the Results Table.

The lighter colors (it is currently set as greyscale) have a higher correspondence with white indicating a 100% correspondence. This corresponds to the verbal statement: "Everybody who entered X also entered Y".
Similarly, darker shades indicate low correspondence with a black square making the statement: "No-one who entered X also entered Y".

The correlation calculation is done on an individual basis and the results normalized.
The diagonol white stripe follows because everyone who entered X also entered X.
However, the results are not a simple reflection about this diagonal given that "everyone who voted for X also voted for Y", does not mean "everyone who voted for Y voted for X". If you see hot spots on your default values, for example, it may mean people are just passing over them and you may be well served to make the question mandatory or have an explicitly non-comittal default, ie "Prefer not to answer", makes a good default.

I experiments with various colors, many highlight better than greyscale, but they either give a headache or will discriminate against the color-blind. I have left it as greyscale, there is one other commented out in the code.

I think that just about wraps up the "analysis" side of the webform unless anyone particularly asks for more. I would argue however, that any deeper analysis, should be done by a proper stats package after downloading the data. This is simply to give you a fast look at the responses so as to better design the questions.

Ullgren, how are you going with the 'txt' extensions on these. Are they working?

Hi, I have added a download to csv under the "download" link on the Webform page. I made the csv flat so it is pretty easy to format under Excel or similar.

Feedback please.

Yes, that last file contains *all* my webform.inc stuff for your comments.

The major changes being:

1. Additions and improvements to the analysis function,
2. Addition of the download function which produces a flat csv file

I would appreciate your help with this last download function, the code is working as far as the users are concerned however throws a warning in the watchdog logs. Presumably something un-PHP/drupal I am doing. I posed a question and more description about it on the drupal forums at http://drupal.org/node/16926 but have not received any replies.

Hi, one improvements and one bugfix to my report patch.

1. Data entered into Textfields is now analysed the same as TextAreas
2. Fixed a bug that was causing incorrect tally statistics when there were multiple webforms on a site. This bug was caused by my failure to correctly group logical filters in the one of the SQL queries. Added some brackets.

If anyone is using this patch, please give feedback.

OK this might sound like a stupid question... but here goes...

How do I add this patch ?

Just save webform.inc in the same folder with webform.module ?

Where do I browse this data ?
Thanks

Yes, just backup your existing copy of webform.inc and download webform.inc_3.txt and rename it to webform.inc It should be in the same folder as webform.module

Make sure you back up the old one so you can go back if you don't like it...

If you have any problems, let me know.

I see the cvs output and the analysis section, coupled with what was there, as the bulk of the report section. As these are now in place am marking this as 'fixed'. Additional sub-report elements can have their own threads.