Unanswered

Pie Chart for Likert Scale Results

(0) Share

Report

Posted on by AdamG87

I am trying to display the total amount of each response type using the pie chart visual in power apps.

The app is a likert scale survey where the answers and a point value for the answer are written to a sharepoint list using a flow

I was told by a coworker that I need to create a a table with a count of how many of each rating, via a collection. I can't get ahold of them anymore and I am lost on what they mean.

Any ideas on how I can go about accomplishing this?

Categories:

Building Power Apps

red2.jpg

red1.jpg

red3.jpg

I have the same question (0)

All responses (2)

Answers (0)

developerAJ 4,643 on at

Like (0)

Report

AddColumns(GroupBy(urfilterformula,"urfeedbackcolumnname","grpname"),"Count",CountRows(grpname))

use this in piechart items

Please click Accept as solution and give it Thumbs Up if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
AdamG87 11 on at

Like (0)

Report

what would group name be in my scenario? I have columns labelled with the questions (Did the facilitator do xzy), and the answer is recording in the column. I then have a column next to each question that stores the point value.
In you example, I understand "urfeedbackcoulmname" would be one of my questions columns. If that's correct, what do I do about the other questions columns (I have 14)? Does "grpname" correspond to my point value columns?

With inserting the urfilterformula, I'm unsure how to write that. I think I have it started:
AddColumns(GroupBy(Filter(colResults, Class = ClassTitle_3.Selected.Value),"
but when I go to type in my column name after that last comma, it isn't finding anything. Would you be able to help me write out the formula?

Was this reply helpful? Yes No