I have a gallery with distinct assignee names i.e XYZ and PQR
For the above sample data , i need 2 pie charts
1) Which will show 'Priority' piechart whenever a assignee i.e either (XYZ or PQR) is selected in Gallery
2) Which will show 'Type' piechart whenever a assignee i.e either (XYZ or PQR) is selected in Gallery
Hi @PAJ,
Certainly! Practicing Power Apps formulas is essential to become proficient in building apps. Here are some effective ways to practice:
Learn the Basics:
Explore the Formula Reference:
Watch Tutorials and Webinars:
Create Mini Projects:
Experiment with Real Data:
Challenge Yourself:
Join Communities and Forums:
Remember that consistent practice and hands-on experience are key to mastering Power Apps formulas. Start with simple tasks and gradually tackle more complex scenarios.
Happy app-building! 😊🚀📱
Thank you it worked . Any tips on how i can practice these formulas ?
Hi @PAJ,
Could you please tell me how you set the Items property pof your Gallery?
This decides how you refer to gallery selected assignee name and Priority.
AddColumns(GroupBy(Filter(data,'Assignee Name'=Gallery.Selected.'Assignee Name'),"Priority","PG"),"PCount",CountRows(PG))
Note that you need to refer to correct returned column name in your Gallery, I refer to 'Assignee Name' directly, you need to check how you set the Text property of the Label where you display 'Assignee Name', the field name after ThisItem is the real field name you need to refer to.
Same as Type PieChart:
AddColumns(GroupBy(Filter(data,'Assignee Name'=Gallery.Selected.'Assignee Name'),"Type","TG"),"TCount",CountRows(TG))
Hi @PAJ ,
Certainly! To create the two pie charts based on the assignee names (XYZ and PQR) in your gallery, follow these steps:
Create a Pie Chart for Priority:
ShowColumns( AddColumns( GroupBy( Filter(Assignees, AssigneeName = ComboBoxAssignee.Selected.Result || IsBlank(ComboBoxAssignee.Selected)), "Priority", "PriorityGroup" ), "Count", CountRows(PriorityGroup), "Label", Priority & ":" & CountRows(PriorityGroup) ), "Label", "Count" )
Create a Pie Chart for Type:
ShowColumns( AddColumns( GroupBy( Filter(Assignees, AssigneeName = ComboBoxAssignee.Selected.Result || IsBlank(ComboBoxAssignee.Selected)), "Type", "TypeGroup" ), "Count", CountRows(TypeGroup), "Label", Type & ":" & CountRows(TypeGroup) ), "Label", "Count" )
Remember to adjust the table or collection names and column names according to your actual data.
If you have any further questions or need additional assistance, feel free to ask! 😊
WarrenBelz
146,751
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional