Report Builder: Create a pie chart showing the field average response

  • ikomyc
    Asked on May 19, 2024 at 7:42 AM

    Hello
    I am trying to get the average response value that generated as below

    Report Builder: Create a pie chart showing the field average response Image 1 Screenshot 20I need to make it a chart and updated instance


  • Silvano JotForm Support
    Replied on May 19, 2024 at 7:52 AM

    Hi Ismail,

    Thanks for reaching out to Jotform Support. Creating a report with your form submission is easy. Let me show you how:

    1. In Submission Table, click the down arrow beside Tables in the top left corner of the page.
    2. Now, select Report Builder on the drop-down.
    3. Finally, select either Extended Report or Compact Report base in your requirement.
      Report Builder: Create a pie chart showing the field average response Image 1 Screenshot 20

    That's it. Give it a try and let us know if you have any other questions.

  • ikomyc
    Replied on May 19, 2024 at 7:57 AM

    Hi Silvano,

    appreciate your fast response

    But I need the highlighted Avg 56.76 to be presented as pie chart

    I can't do this by creating a report

    how to make it ?

    Thanks.

  • Mary_Ed JotForm Support
    Replied on May 19, 2024 at 8:06 AM

    Hello Ismail, 

    Thanks for getting back to us and we’re sorry you’re having trouble with this. I understand the request, but I’ll need a bit of time to look into its possibility. I’ll get back to you as soon as I can.

    Thanks for your patience and understanding, we appreciate it.


  • Mary_Ed JotForm Support
    Replied on May 19, 2024 at 8:32 AM

    Hello Ismail, 

    Thanks for your patience. I found that you can view this average result as a Pie Chart by clicking on the Summarize with a chart option for a specific column. Let me show you where to find this option:

    1.  On your Jotform Tables page, click on the Number column.
    2.  In the list that comes up, click on Summarize with a Chart.
    3.  You can change the chart type by clicking on Chart Type on the right side of the page.

    Report Builder: Create a pie chart showing the field average response Image 1 Screenshot 20

    Give it a try and reach out again if you have any other questions.

  • ikomyc
    Replied on May 19, 2024 at 8:55 AM

    Hello Mary,

    appreciate your fast response

    But Summarize with a Chart. is not consider the Avg at all 

    it's just summarize how many submission have same value, But I need the average of submissions values

    I need to make this Avg 56.47 percentage Pie Chart


    how to make it ?

    is there are some work around to got it chart for Avg ?

    Please advice

    Thanks.

  • Silvano JotForm Support
    Replied on May 19, 2024 at 9:04 AM

    Hi Ismail,

    Thanks for getting back to us. Unfortunately, there's no option to automatically generate a chart containing the average of the submission result, as the default calculation is based on the percentage based on the responses. You will need to manually create the report.

    Let us know if you have any other questions.

 
Your Answer