3
I can see how get access to the Choice type on the Gallery card like columnname.value
But now I m trting to make a Pie Cart of all items in X status where status is a choice field
I can make a pie cart from the standard feilds that are exposed doing like
AddColumns(GroupBy('Migration Tracking' ,"feild" ,"Allresults"), "result" , CountRows(Allresults))
The Problem is those Choice type columns are not exposed as a column 😞
Any ideas thanks
Hi cdstg,
I assume that you will need to combine a Filter function within the code.
Add a Dropdown control, set its Items property with the selection in your Choice column. In my case, there are three selection in the Status column, so I set its Items property as ["Closed","Pending","Other"].
Add a Pie chart control, set its Items property as
AddColumns(GroupBy(Filter(ProjectEmail,Status.Value=Dropdown1.Selected.Value),"Title","Title_1"),"Count",CountRows(ProjectEmail))
Hope this could be a reference for you.
Please try it on your side to see if it will work for you.
Best regards,
Mabel Mao
Share
Report
All responses (
Answers (
