PowerApps Dashbord with SharePoint List

I've got 2 tasks below: Task #1: Build a collection from SPList with grouping of data as needed Task #2: Create a PowerApp to present the data in a dashboard Please pay attention to these: ClearCollect, AddColumns, GroupBy, CountRows, and Sum Core of this project is the process of collection creation as below for grouping and aggregating the data from SharePoint list.: ClearCollect( colOrderSummary, AddColumns( GroupBy( PurchaseOrder, "Status", "Grouped" ), "Count", CountRows(Grouped), "sum_OrderTotal", Sum( Grouped, OrderTotal ) ) ); Also notice that we re-use one collection on 3 different objects datatable, pie char and bar chart in our App making our App is optimized for performance.