Is there a way in Reports to total columns while using the Survey Tool - Matrix?

  • Profile Image
    redeemerit
    Asked on February 17, 2016 at 03:40 PM
  • Profile Image
    Chriistian
    Answered on February 17, 2016 at 09:34 PM

    If I understand correctly, you want to calculate the total result of selected columns from the Survey Tool - Matrix? If yes, then you can do so by using a form calculation widget. Simply follow this guide on how to set it up for your form: How to perform form calculation in the Matrix field

    Once that is set up, the total can then be displayed in the reports created.

    Here's a cloned version of your form where I added the form calculation: https://form.jotform.com/60477945980975

    You can clone it to your account by following this guide: How to Clone an Existing Form from a URL

    Let us know if you need further assistance.

  • Profile Image
    redeemerit
    Answered on February 17, 2016 at 11:46 PM
    Thanks so much for this detailed response.
    As I have gotten into this deeper I realized I don't need column totals.
    My goal is to rank the 4 topics I listed in the women's retreat form to see
    the most requested topic to the least requested.
    Is that possible?
    ...
  • Profile Image
    Chriistian
    Answered on February 18, 2016 at 01:04 AM

    You can use the Visual Report Builder to see the most requested topic. Here is a guide on how to create it: How to Create a Visual Report with your Form Submissions

    You can also check out this guide to customize your report even more: How To Use Visual Report Filters

    Do let us know if you need further assistance.