Forum Discussion

edzkulasa's avatar
edzkulasa
New Member
4 years ago
Solved

Survey Responses

Hello All

 

I am trying to create a Card Visualization that will only shows the percentage of 'Happy & Neutral' responses out of total survey questions responses.

 

The table data as shows below and I want to know what measurement I should use or alternative method should I use. I hope someone can help?

 

Request IDSurvey QuestionRating
12496How was your experience?Unhappy
12496How happy are you with support?Unhappy
2649How was your experience?Happy
2649How happy are you with support?Happy
3102How was your experience?Happy
3102How happy are you with support?Neutral
5380How was your experience?Happy
5380How happy are you with support?Happy
5455How was your experience?Happy
5455How happy are you with support?Happy
5410How was your experience?Happy
5410How happy are you with support?Neutral
4843How was your experience?Happy
4843How happy are you with support?Happy
7350How was your experience?Happy
7350How happy are you with support?Unhappy
Tips and Tricks
  • johnt75's avatar
    johnt75
    4 years ago
    Happy & Neutral % =
    var totalResponses = COUNTROWS( 'Responses' )
    var happyNeutralResponses = CALCULATE( COUNTROWS( 'Responses' ), TREATAS( { "Happy", "Neutral" }, 'Responses'[Rating] ) )
    return DIVIDE( happyNeutralResponses, totalResponses )

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago
    Happy & Neutral % =
    var totalResponses = COUNTROWS( 'Responses' )
    var happyNeutralResponses = CALCULATE( COUNTROWS( 'Responses' ), TREATAS( { "Happy", "Neutral" }, 'Responses'[Rating] ) )
    return DIVIDE( happyNeutralResponses, totalResponses )