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?
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?
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.
WarrenBelz
146,537
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,908
Most Valuable Professional