Visual Reports: Display input table values in matrix view

  • Profile Image
    questionarios
    Asked on November 17, 2020 at 05:52 AM

    Hello,


    How is possible to create a graphic with Matrix values like this?

    1605610165_5fb3aab5cd485_

    If I resume the answers in a graph this is the result:

    1605610288_5fb3ab301c76a_

    Best Regards

    Henrique

  • Profile Image
    Richie_P
    Answered on November 17, 2020 at 06:19 AM

    Unfortunately, it is not possible to change the graphic of the input table on the reports.

    https://www.jotform.com/help/326-how-to-create-form-reports-in-jotform

    You may try creating a PDF document out of your submission.

    Sample output

    1605611895_5fb3b17761a3b_2.png

    https://www.jotform.com/help/384-how-to-customize-pdf-submissions-report

    Please give it a try and let us know if this fits your requirements.

  • Profile Image
    questionarios
    Answered on November 17, 2020 at 06:37 PM

    Hi,

    No, there is no way to have this scenario as you said.

    I need to have the array values ​​counted.

    Like for example

    The average that the math teacher had on arrive on time.

    The average that the math teacher had in the field of knowledge.

    The average that math teacher had in his team-building activities.

    The average that the math teacher had in the relationship with the students

    The average that the math teacher had in the assessment justice.


    1605656151_5fb45e578041a_

    I hope that I have expressed it correctly so that you can understand.

    Best Regards

    Henrique

  • Profile Image
    Lorenz_A
    Answered on November 17, 2020 at 09:57 PM

    Unfortunately, it's currently not possible on the visual report to display it like what is shown in the image you've posted. The input table in the reports only offers a bar chart and column chart display.

    Let me forward this to our developers and to see if this is something they can add or improve. However, we cannot provide any ETA on when will this be implemented.

    We'll keep you posted via this ticket for any updates.

    Thank you.

  • Profile Image
    questionarios
    Answered on November 20, 2020 at 07:34 AM

    Hi,

    This my image is a example of one subject, on the visual report is ok to display all subjects.

    The question is the analysis of the average answers that the user filled.

    Your analysis is how many answers were made, but I need the average value of the ansewers.


    Regards

    Henrique

  • Profile Image
    Welvin
    Answered on November 20, 2020 at 08:15 AM

    Hello Henrique,

    Unfortunately, I find no way to get the average of the answers. You are referring to the average of the overall form submissions, right?

    The Input Table is separated into multiple cells in the Excel report, so you may consider getting the file, and use the Excel formulas to get the average.

    Download: https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF.

    Average formula guide: https://support.microsoft.com/en-us/office/calculate-the-average-of-a-group-of-numbers-e158ef61-421c-4839-8290-34d7b1e68283

    I hope that helps.

    Please contact us again if we can help in any way.

  • Profile Image
    questionarios
    Answered on December 14, 2020 at 08:10 PM

    Hi Welvin

    I

    now how to do in Excel, exporting the submissions in excel and prepare the content, but I think it will be a good idea to implement this kind of output, is very usefull for matrix fields.

    Please considere this new feature for a near future.

    Best Regards

    Henrique

  • Profile Image
    Lorenz_A
    Answered on December 14, 2020 at 09:56 PM

    Hi there,

    I will be passing this idea as a feature request to our developers, and you will be updated in this ticket https://www.jotform.com/answers/2766512 if in case this got implemented.

    Thank you.

  • Profile Image
    questionarios
    Answered on December 18, 2020 at 07:01 AM

    Super.

    Best Regards

    Henrique