ClearCollect(
distinctStatus,
Distinct('OneEng Candidates', GeneralStatus)
);
produces this collection:
I'm trying to count how many times each result appears in a common data source:
I am trying to do this by using ThisRecord.Result. I can create a mirror column, testing to make sure its referencing the correct "status:
ClearCollect(countStatus, AddColumns(distinctStatus, "Test", ThisRecord.Result))
Hard coding in a status works as expected:
ClearCollect(
countStatus,
AddColumns(
distinctStatus,
"Test",
CountRows(
Filter(
'OneEng Candidates',
Text(GeneralStatus) = "Loop-Scheduling"
)
)
)
)
However, when I try to change "loop-scheduling" to "ThisResult.Record", it won't recognize it as an object and it doesn't work:
What am I doing wrong? Is there a way to reference the "current row" inside filter?
