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 dissatisfied are the fields for this task. I want to display satisfied + very satisfied as a percentage of the total. 

  • 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/

     

     

9 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi Anonymous 

    Try this measure:

     

    Measure = 
    Var _SVS = Calculate(counta(table[column with data],filter(all(table),table[column with data]="satisfied"&&table[column with data]="very satisfied"))
    Var _AO = Calculate(counta(table[column with data],filter(all(table))
    return
    _SVS/_AO

     

    Change the Measure format top Percentage and replace the red items in measure with the column name that has those items.

     

    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

      what am I doing wrong here? VahidDM 

      • VahidDM's avatar
        VahidDM
        Super User
        4 years ago

        Anonymous 

         

        Just change the red text with column name between [  ] and then ="...".

         

        Copy and paste the measure here as a text not image then I will update that.

         

         

        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/