I have a Sharepoint list which have a column with a Choice value, I want to show how many times each value is repeated in a Pie Chart on my Power App.
When I select the chart and tell it on the Item properties to read my Sharepoint list data, it only goes green and shows the number of items. Example screenshot:
What I want now is to show the specific column (which is a Choice column) and give each of the options a different color.
I've been investigating and found this link with a formula, but I just can't figure out how it works, because for me is just errors.
Here's the formula from the link:
AddColumns( GroupBy( AddColumns('20190102_case6',"NewFieldName",Office_Name.Value), "NewFieldName", "GroupData" ), "CountByOffice", CountRows(GroupData) )