What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Why do reports not show answers for Matrix rows?

    Asked by ConciliumGroup on January 04, 2012 at 10:28 PM

    Hi There,

     

    I am really enjoying using JotForm and learning a tremendous amount in the process. Now that I have got the hang of creating forms and publishing them, I am looking to your reporing feature to enhance the overall delivery.

    I created a form which had a matrix question set and I noticed that when I looked at the report (Pie, bar, etc), the report only gave totals for the number of responses given in each of the column headings but did not separate this by row. It is the row where the measurement criteria is placed. Please see the screenshot for Matrix questions sample.

    When the report is generated, it will show the Matrix question title and then the number of responses for each of the columns (answer options - Good, average, Poor, etc), but does not show this for each of the rows. I know I will get this data in the .csv extraction but it would be nice to have it already in the report.

    If the reporting function is not a priority feature, perhaps we could get data exportable to Excel in the matrix form (see screenshot - bottom matrix), where the totals appear in each cell. If we need to do any detailed reporting, calculations, we can then do this in Excel directly. (Just a thought).

     

    Cheers,

     

    Guy

    Screenshot
  • Profile Image

    Answered by paoloumali on January 05, 2012 at 03:44 PM

    Thank you for your thoughts on these things.

     

    I will create a ticket adding your suggestions as I've seen some threads where such feature is requested. Our developers are still occupied with several tasks so please be patient with us. I myself would like to see JotForm being able to report matrix results in the manner that you described.

     

    But please take note that such a task may require more developer hours as the use of a matrix is varied per user. In your case, you only have specific options selected(Extremely Important, Very Important, etc..) while for some, they may have a matrix of input fields which will most likely be dynamic in nature.

     

    At the mean time, please consider using the Grid Reports(generated in the same way that you made your Visual Reports) as a temporary way to report data if you needed it embedded in your website's page. http://www.jotform.com/grid/20043802459

    It may not show the totals like you wanted but at least, this is better than just the graphs earlier.

     

    Thank you for using JotForm

  • Profile Image

    Answered by ConciliumGroup on January 05, 2012 at 06:34 PM

    Okay noted with thanks. Will eagarly wait to see your developments with this in the future.

     

    Cheers,

     

    Guy

  • Profile Image

    Answered by alliphil on January 05, 2012 at 08:39 PM

    Wow, I just used this question on the most critical question on my annual business survey.  Didn't realize that I couldn't run reports on rows using a matrix question, and didn't even think to test it first.  Very disappointed, but eagerly awaiting this feature.

  • Profile Image

    Answered by paoloumali on January 05, 2012 at 08:50 PM

    JotForm allows extending what it currently provides. It will require some JavaScript skills though.

    In Reports, one of the options is RSS Listing which can be used by any programmer who knows how to parse XML. Here's a sample listing: http://www.jotform.com/rss/20044922450

  • Profile Image

    Answered by alliphil on January 05, 2012 at 08:56 PM

    Parsing XML and Java script skills are outta my league, but thanks for the suggestion nonetheless. 

    I'll see if I can somehow salvage the data by exporting it to Excel and using Excel's "count" functions.  I've not tried to export it to excel so I'm not sure what it looks like but seems worth a shot given I don't have any other options at the moment.

  • Profile Image

    Answered by paoloumali on January 05, 2012 at 09:09 PM

    This thread might give some ideas too. http://www.jotform.com/answers/53902-Matrix-Report-Solution

  • Profile Image

    Answered by nike air max on March 15, 2012 at 11:19 PM

    Vans Vault jordan shoes uk Chukka nike air max 180 uk Buckleback LX nike air max 95 sale - Navy + Beige | August 2010 Dropping nike air max 2012 trainers on the first of August is the Vans Vault Chukka women air max 90 Buckleback LX in two colorways. buy air jordans The Chukka Buckleback LX ?features nike air max ltd shoes a canvas monochrome upper with a canvas cheap nike air max 2011 toecap, white vulcanized midsoles, nike air presto uk cheap air max 97 leather trim on the seams, metal lace eyelets, and a buckled belt on the rear ankle of the shoe. Again, both colorways of the Vans Vault release is set to release on August 1st so check your local Vans Vault accounts then. via?HS.The last shoe in the Black Animal Pack is this Stingray inspired Official, again in black and featuring a stingray pattern on a good part of the shoe. The Black Animal Pack features the Wolf Americana Mid Lux, Spider Questar, and this Stingray Official. The pack will be available at Mess in Beijing starting Saturday, December 18th.v