Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Use forms categories to calculate average

I'm working on a visual that should calculate the average per [certain filter].  The categories would look something like:  fully disagree, disagree, neutral, agree, fully agree  And there are mul...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Anonymous ,

    When plotting a bar graph, it is mandatory for the other field to be an aggregation to display a bar.
    Here, x-axis cannot be a text field when y-axis is already a Dimension field.
    By using the measure provided you can show average rating by Business unit or you can make use of Small Multiples feature to have a clearer understanding of the data.

    Below snap for reference-

    Hope this helps!
    If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
    Thank you.

Sonalika's avatar
Sonalika
Regular Visitor
1 year ago

Anonymous  Assuming you have mapped numbers to categories as : 
Fully Disagree -2 ,Disagree -1,Neutral 0,Agree 1,Fully Agree 2

Use the following to create a calculated column that assigns a number to each category :
LikertValue =
SWITCH(
[YourColumn],
"Fully Disagree", 1,
"Disagree", 2,
"Neutral", 3,
"Agree", 4,
"Fully Agree", 5
)
Now create a measure to calculate the average Likert score:
AvgLikert = AVERAGE(YourTable[LikertValue])

This will show the average score, but still allows you to use category labels for context.

Hope this helps!!! 😊