Hi @sean8397 ,
Depending on the Data source, you may be able to take a different approach:
ForAll(
GroupBy(
Data,
"Request",
"Data"
),
{
Request: ThisRecord.Request,
Number: CountRows(
Filter(
Data,
ThisRecord.'CreatedOn' >= Date(
Year(Today()),
Month(Today()),
1
) && ThisRecord.'CreatedOn' < DateAdd(
Date(
Year(Today()),
Month(Today()),
1
),
1,
TimeUnit.Months
)
)
)
}
)
You'll need to change some of the field names to fit your data source,
Data: Your Data source name
CreatedOn: The equivalent Date field in your data source
Request: The Request field in your data source
What we're doing essentially creating a new table with requests against a count of the records with that request. We're filtering our requests to be from the 1st of the current month to the end of the month.
