138
Hello everyone,
I added a Pie chart to a gallery and it works fine with the below code, but I would like to sort the columns by Presence, how add sort function to the code?
AddColumns(GroupBy(AddColumns(Gallery_Attendance.AllItems,"P",Presence),"P","Presence"),"Number",CountRows(Presence))
Thank you
Hi @Greg68 ,
As P is Presence, just do this
Share
Report
All responses (
Answers (
Sort(
AddColumns(
GroupBy(
AddColumns(
Gallery_Attendance.AllItems,
"P",
Presence
),
"P",
"Presence"
),
"Number",
CountRows(Presence)
),
P
)not sure why you did not call the grouped column something else here
Sort(
AddColumns(
GroupBy(
Gallery_Attendance.AllItems,
"Presence",
"Data"
),
"Number",
CountRows(Data)
),
Presence
)
Please click Accept as solution 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.
Visit my blog Practical Power Apps
