Jump to content
  • 0

How to make chart for survey results


BeffreyJezos
 Share

Question

I have a simple table that contains the results from survey and I want to make a chart datapage from it for a presentation.  The problem I am having is that I can seem to plot the values in a chart. 

image.png.fc8fb8d0016a08158dd1a2bafc34dd87.png

This is what the table looks like. I know it isn't numerical values but I cant seem to find a way in the datapage wizard to use formulas. I plan on visualizing the popularity of each options (a,b, or c) for each question. 

Any ideas is welcome. Thanks.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi,

The simplest way I can think of is to create a new table that is chart-able in a sense that it contains numerical results (like the count of each option chosen by your participants) and use Task to insert values to the new table. Here is an sample task that I made based on your screenshot:

image.png.cb2074e7435da4addeb1823800710f6d.png

The new table in this sample is "Chartstbl". This is, however, assuming that you only need the current values for your presentation. If there will be new records to your Survey table in the future, then you may need to create a Triggered Action instead. This is also assuming that there are only 3 choices as seen in your screenshot (a,b, and c). You will need to create another Insert block for each of the questions. Its kind of a hassle to do that but there is a duplicate function when you right-click on the insert block. That might help a bit.

This is how the new table looks like after running the task.
image.png.0c4a3a62c8f934ef5130f0514c15011d.png

With this table, you can use QuestionNo as the Category field and the three other columns as the Value fields.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...