
Announcements
I am attempting to nest a GroupBy within itself because I'd like to take my entries from a SharePoint list and display them on a Power Apps line graph.
Current scenario is users go out to locations and swab items for bacteria for testing. They gather a reading (Number column) and log that depending on the Facility as well as which Department they were in.
Ideally I would like to get the average reading per each Facilities' Department.
Right now I'm using Single Line for my Facility and Department columns.
This is as far as I'm able to get with everything working. The current formula is my OnVisible for the screen.
Hi @NathanFra
We can use nested Group By Column like
AddColumns(
GroupBy(
Datasource,
"Col1","col2","NewTableName"
),
"NewcolumnName", Average(NewTableName,ColToaverage)
)