Forum Discussion

inickqc's avatar
inickqc
Regular Visitor
3 years ago
Solved

Isolating a multiple choice response inside a collumn

OK, I am about to close the computer and become Amish.   I have a survey for 50 people, asking them about ten software. We ask them if they are willing to help people learn it or would like to impr...
Need Help
  • JoeBarry's avatar
    JoeBarry
    3 years ago

    Hi inickqc 

     

    I made a copy of the data to my drive, I couldn't connect to your drive. 

     

    I made the following steps

    • Imported through the Google Sheets connector
    • I promoted the Programms as the columns headers
    • Removed the last two columns
    • Highlighted all columns and unpivoted them.
    • I removed some text from the Program names
    • I also removed the .1 & .2 at the end of each program name

    I loaded the data in and created the below example for you to check

    https://drive.google.com/file/d/1gshoL7z6WVDxSKdeHvRBdxlJ2wgWFNvf/view?usp=sharing 

  • JoeBarry's avatar
    JoeBarry
    3 years ago

    Before loading the data, remove this relationship in the Model view for all tables that are linked to it. After loading in, create the relationships again. This time they will be Many to Many. Change the Cross Filter Direction to what you need

JoeBarry's avatar
JoeBarry
Solution Sage
3 years ago

Hi inickqc 

 

Within the Answer column is there a delimter seperating both answers?

 

You can highlight the column with the answer and in the ribbon > Transform choose split be delimiter. Choose the delimter that's in the column between the answers and press ok. If the delimter is a symbol and a space, then enter the delimter manually and add the space too.

 

This will create another column. Highlight both columns and right click and choose unpivot columns. This will create two new columns. One with the Question and the second if the question has been answered. 

 

Load the data into the report. Create a slicer with the Software Column and a Slicer with Question column.

 

This should help

 

Thanks

Joe 

 

If this post helps, then please Accept it as the solution

inickqc's avatar
inickqc
Regular Visitor
3 years ago

Hello

 

Thanks for the quick answer

 

I already had them sliced and unpivot but could not make sense of the result.

 

I believe this will work, but I do have one error.

 

I gave everyone an index number by creating an index column when I started manipulating the data to ensure I had something to link any answers to the people. By unpivoting, the system does its job and attributes, for example, the number 1 to every response of user 1. 

 

The problem is that the system cannot accept more than one number 1.

 

See the attached screenshot.

 

Any idea?

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    3 years ago

    Good morning, 

     

    sorry my idea didn't help. If you can share a sample of the data if it isn't too sensitive, i will take anothe rlook. To override your new issue, disable the Relationship between the tables first and then load again

     

    Thanks

    Joe