Content migrated from TechNet. Post attribution to: PK Hong
GroupBy - which is not available in Project Siena, appears to be very fast in providing data filtering with multilayer filter.
I used for my Farm Apps - where I have 4 farms with many houses per farm. I can easily use GroupBy to show for each Farm, the details for each House and the statistics with graph.
E.g.: ClearCollect(HousebyFarm, GroupBy(TableFarmReport, "FarmName", "HouseNo", "HouseGrp")); If(HousePerformance = true, UpdateContext({HousePerformance: false}), UpdateContext({HousePerformance: true}))
Based on TableFarmReport, we can have Multi-Layers filter, such as FarmName, HouseNo, and even specific species or day.
I used to make the HouseGrp Hidden and one CLICK of a DropDown on the FarName, the GroupBy works perfectly.
Very useful for data presentation for Management and can be realtime with Refresh (on Time End) [Though I wish in future, PG can include Push Notification].
