- sorbiesAsked on May 11, 2011 at 08:21 PM
Before I create a survey, I was wondering if I was able to generate a report from survey results which can then be exported to MS Excel?
Thanks for your help,
- JotForm SupportmlizAnswered on May 11, 2011 at 09:19 PM
- mathetosAnswered on August 02, 2011 at 12:08 AM
But I think the source of the question is: "What kind of data will be provided in this exported document?" Will it be a tally or average of all the scores of all the submissions? Or will it just be a database of all the submissions next to each other and all actual data analysis will have to be done by hand? Can you clarify or even post an example?
- JotForm SupportmlizAnswered on August 02, 2011 at 01:30 AM
The exported csv/excel file will contain all of the submissions in the database
for the selected form. This does not include any analysis or tally, its a plain output
of all data gathered. A sample of the MS Excel report can be found here:
For analysis the of the data submitted you may use Visual Report. It can
create percentage reports and charts from your checkbox/radio/dropdown questions.
To create a Visual Report for a form:
1. Login to JotForm
2. On "My Forms" page select your form and then click "Reports"
3. Select "Visual Report Builder" from the option
You can find a live example of the report from this page.
You can use several options for the report such as Pie, Bar and line. For further
information on how this can be achieved please visit the page below:
Hope this helps.
Let us know if you have clarifications.
- convenusAnswered on December 12, 2011 at 07:55 AM
I generated a Visual Report, the problem is that I only have the first 2 pies but what about all the others ? (there is no drop button) ...
- JotForm SupportliyamAnswered on December 12, 2011 at 08:49 AM
We have received requests regarding the visual report to increase the white space area's height due to that users find the allowable area to create the reports too small. So far we have no updates from our developers regarding this. For now, what you can do is simply create more visual reports by adding a new report.
Can you also please explain further what you mean by 'there's no drop button'? Thanks.
- convenusAnswered on December 12, 2011 at 09:21 AM
I can not go down on the page. Maybe a full report has been generated but I can not know.
- JotForm SupportliyamAnswered on December 12, 2011 at 09:49 AM
If I'm not mistaken, what you did was you dragged and placed the other charts to the not-visible area. But just to be certain, can you please tell us the ID or the URL of the form?
The visual report can only accommodate a number of reports due to the limited space. But you can simply create multiple visual reports and place your other charts on the new one.
- convenusAnswered on December 12, 2011 at 11:31 AM
Here is the URL. As you will notice the following problem occure:
-> It's adding together different questions before displaying the outcomes, therefore distorting the results...
- JotForm SupportMike_TAnswered on December 12, 2011 at 04:59 PM
Are you looking for a Chart Data DropDown to change the content of some report Element? Please take a look at the following screenshot:
If the problem is not related to this picture, please explain the issue more detailed.
Thank you for cooperation.
- convenusAnswered on December 13, 2011 at 07:14 AM
URL of my form: http://form.jotform.com/form/13295852108&forceDisplay=1&prev
I have differents charts and each one have two or more rows.
What I need is two different graphic: 1 graphic for the content and 1 graphic for the presenter (for charts which have two rows) but 4 different graphics for those which have 4 rows, so that my results are not distort.
The problem is that on your graphic the two rows are added (content + presenter), which makes my study completly wrong.
- JotForm SupportliyamAnswered on December 13, 2011 at 10:31 AM
The charts can only get results from survey field elements, individually. Example, if you have one question that collects answers for good, better, or best, then it will only show the result from that question. You cannot collect and graph the data of two separate questions.
If you wish to chart the data from different questions, I can suggest that you download the excel data and use the pivot table feature. Here are some website pages that can help you understand more about pivot tables:
- guest_23108878515055Answered on November 22, 2012 at 02:41 AM
can i create a form, where at the end of it, the user's input turns into a template for the user to view?
- fxrAnswered on November 22, 2012 at 02:49 AM
Please open a new thread for this new request giving as much detail as regards what you hope to achieve.