Likert Data missing

%3CLINGO-SUB%20id%3D%22lingo-sub-1390038%22%20slang%3D%22en-US%22%3ELikert%20Data%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1390038%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20looking%20for%20some%20help!%3C%2FP%3E%3CP%3EI%20have%20created%20a%20form%20-%20and%20the%20survey%20has%20gone%20live%20-%20150%20responses%20so%20far.%3C%2FP%3E%3CP%3EIn%20this%20form%2C%20I%20used%20several%20Likert%20questions%20where%20I%20asked%20questions%20like%20%22What%20level%20of%20involvement%20do%20you%20have%20in%20the%20budget%20process%3F%22%20and%20I%20set%20option%20of%204%20Likert%20'buttons'%20with%20the%20left%20one%20being%20%22Low%22%20and%20the%20right%20one%20being%20'High'.%3C%2FP%3E%3CP%3EThe%20middle%202%2C%20I%20deleted%20the%20headings%20altogether%20-%20as%20they%20were%20the%20in-between%20options.%3C%2FP%3E%3CP%3ESo%2C%20now%20people%20have%20completed%20the%20survey%20-%20the%20graphs%20show%20the%20nice%20split%20of%20the%20responses%20-%2057.2%25%20High%2C%208.7%25%20Low%2C%20and%20button%202%20is%2015.2%25%2C%20and%20button%203%20is%2018.8%25%20-%20the%20graph%20works%20fab.%3C%2FP%3E%3CP%3EBut%20-%20and%20here%20is%20the%20issue%20-%20when%20I%20export%20to%20excel%20%26nbsp%3B-%20the%20data%20table%20only%20shows%20the%20words%20'High%22%20and%20'Low'%20and%20the%20other%20options%20that%20were%20clicked%20(Option%202%20%26amp%3B%203)%20didn't%20have%20a%20column%20heading%20-%20so%20are%20just%20left%20blank%20in%20the%20data%20table.%20So%20I%20cannot%20use%20the%20data%20table%20to%20interpret%20the%20results.....%3C%2FP%3E%3CP%3EThe%20application%20clearly%20knows%20what%20the%20buttons%20were%20-%20as%20it%20is%20producing%20the%20graph%20showing%20what%20was%20selected%20-%20but%20the%20data%20when%20I%20extracted%20gives%20the%20column%20headings%20as%20blank%20-%20so%20I%20cannot%20interrogate%20those%20middle%20answers%20%3Aastonished_face%3A%3Aastonished_face%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20how%20i%20access%20the%20information%20that%20is%20clearly%20been%20gathered%20-%20but%20is%20not%20visible%20to%20me%20in%20the%20data%20table%3F%3C%2FP%3E%3CP%3EThanks%20a%20million%20in%20advance!%3C%2FP%3E%3CP%3EBest%3C%2FP%3E%3CP%3ENeale%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1390038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi - looking for some help!

I have created a form - and the survey has gone live - 150 responses so far.

In this form, I used several Likert questions where I asked questions like "What level of involvement do you have in the budget process?" and I set option of 4 Likert 'buttons' with the left one being "Low" and the right one being 'High'.

The middle 2, I deleted the headings altogether - as they were the in-between options.

So, now people have completed the survey - the graphs show the nice split of the responses - 57.2% High, 8.7% Low, and button 2 is 15.2%, and button 3 is 18.8% - the graph works fab.

But - and here is the issue - when I export to excel  - the data table only shows the words 'High" and 'Low' and the other options that were clicked (Option 2 & 3) didn't have a column heading - so are just left blank in the data table. So I cannot use the data table to interpret the results.....

The application clearly knows what the buttons were - as it is producing the graph showing what was selected - but the data when I extracted gives the column headings as blank - so I cannot interrogate those middle answers :astonished_face::astonished_face:

 

Can anyone help with how i access the information that is clearly been gathered - but is not visible to me in the data table?

Thanks a million in advance!

Best

Neale

 

0 Replies