Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Card visual help

I have a survey data that has 5 different responses, I want to show the percentage of two fields compared to the total 5 fields.    Very satisfied, satisfied, neutral, dissatisfied, very dissatisfi...
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Anonymous 

     

    Try this:

    Satisfication with Provider = 
    VAR _SVS =
        CALCULATE (
            CountA('Qualtrics Survey sample data'[Satisfaction with provider]),
            FILTER (
                ALL ( 'Qualtrics Survey sample data' ),
                'Qualtrics Survey sample data'[Satisfaction with provider] = "Satisfied"
                    || 'Qualtrics Survey sample data'[Satisfaction with provider] = "Very satisfied"
            )
        )
    VAR _AO =
        CALCULATE (
            CountA('Qualtrics Survey sample data'[Satisfaction with provider]),
            ALL ( 'Qualtrics Survey sample data' )
        )
    RETURN
        _SVS/_AO

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn: 
    www.linkedin.com/in/vahid-dm/