I'm still getting used to powerapps and where/how to put formulas, etc. Thanks for the help.
My app is connected to a Sharepoint list.
I have users inputting a specific color every day. They choose from 4 different colors. So each day, there are say 10 entries, each of those entries one of the 4 colors.
I would like to show what percent of the total number of choices are each color, for each day.
So for example: Say on 10/24/2022 we had 4 total entries. 2 people choose green. 2 people choose yellow.
So I would like to calculate that for 10/24/2022, we had 50% green and 50% yellow.
Ideally after that I would like to make a plot (like a 100% area bar chart on powerBI) that shows these percentages, i.e. a bar with 50% green and 50% yellow.
I'm trying to use some combination of Filter(myList,Date=Today()) and sums, but I'm a little lost.
Thanks for the help!
