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/

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This is awesome, it works as intended except for one small issue. The field can also be empty if the response wasnt filled for that field and as such it is counting the total rows (including blank rows)

VahidDM's avatar
VahidDM
Super User
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/