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

Here is the sample data. I want to display the % of contacts happy (satisfied and very satisfied) with the provider as a card. 

 

Contact Fields - Recipient Last NameSatisfaction with qualSatisfaction with provider
HarmeyNeither satisfied nor dissatisfiedVery satisfied
BrownDissatisfiedNeither satisfied nor dissatisfied
SuttonSatisfiedNeither satisfied nor dissatisfied
LiangVery satisfiedVery satisfied
FlemingSatisfiedSatisfied
CampbellVery satisfiedNeither satisfied nor dissatisfied
GreenSatisfiedSatisfied
UrquhartVery dissatisfiedVery dissatisfied
PrestonNeither satisfied nor dissatisfiedNeither satisfied nor dissatisfied
Kacho OchanaVery satisfiedVery dissatisfied
MacriSatisfiedSatisfied
WalkerVery satisfiedVery satisfied
WattsSatisfiedNeither satisfied nor dissatisfied
MillerSatisfiedSatisfied
PaddenVery satisfiedVery satisfied
ChenVery satisfiedVery satisfied
LimbrickNeither satisfied nor dissatisfiedNeither satisfied nor dissatisfied
MartinNeither satisfied nor dissatisfiedNeither satisfied nor dissatisfied
OngSatisfiedVery satisfied
AuliaSatisfiedSatisfied
TaylorSatisfiedSatisfied
WharemahihimakoVery satisfiedVery satisfied
VahidDM's avatar
VahidDM
Super User
4 years ago

Hi Anonymous 

 

Try this:

Satisfication with Provider = 
VAR _SVS =
    CALCULATE (
        COUNTROWS('Qualtrics Survey sample data'),
        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 (
        COUNTROWS('Qualtrics Survey sample data'),
        ALL ( 'Qualtrics Survey sample data' )
    )
RETURN
    _SVS/_AO

 

Output:

 

 

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/