Forum Discussion

russm's avatar
russm
Icon for Helper I rankHelper I
10 years ago
Solved

Creating friendly-named data names in slicers

Hi All,   I suspect my problem is a simple one but I’m stuck nevertheless.   I am analyzing a survey dataset. The data came from the vendor from with all binary response data coded as “Yes” or “N...
Need Help
  • chrisu's avatar
    chrisu
    10 years ago

    Vvelarde's solution will get you what you need if you do decide to convert the responses to numerical data.  I have recently done a lot with analyzing survey data, and here is what I do:

     

    Break the dataset into 3 tables

    Respondents (unique respondents with any unique demographic data)

    Questions & Responses (includes a unique Question/Response merged field that can be related to the Results table)

    Results (all respondent/question/response pairs and a Question/Response merged field)

     

    Create 3 basic measures

    CountResponse (calculate/count how many selected a given response)

    CountRespondents (calculate/count how many answered a given question (all responses))

    %Response (divide CountResponse by CountRespondents)

     

    Then I add a slicer for a user to select a question and display the %Response by Response in a chart.  You don't need to code/convert the responses because Count will take in text, and in my mind it is just as easy as using other summation techniques.  This scales well for the hundreds of questions I am working with.