Hello -
I have an app built using SharePoint as my data storage. I would like to take one of my columns (called RAU) with a variety of different categories and calculate the total number of records in the list and break the sum down by each category.
I’m trying to build out a dashboard that will allow my users to see the number of records by each category in that column.
@epannell3223 - you can leverage the GroupBy function. For example, you can apply the below to the Items property of a Gallery:
Share
Report
All responses (
Answers (
15,689
DropColumns(
AddColumns(
GroupBy(
'Your Data Source',
"Your Category Column",
"GroupedItems"
),
"Sum Value",
Sum(
GroupedItems,
'Your Number Field'
)
),
"GroupedItems"
)
Or generate the same table using a Collection:
ClearCollect(
MySolution,
DropColumns(
AddColumns(
GroupBy(
'Your Data Source',
"Your Category Column",
"GroupedItems"
),
"Sum Value",
Sum(
GroupedItems,
'Your Number Field'
)
),
"GroupedItems"
)
);
