ClearCollect(
test1,
Choices('HM InterviewStatus')
);
this turns an option set into a collection:
ClearCollect(
test2,
ForAll(
test1,
CountIf(hm_request_can_id, InterviewStatus = Value)
)
);
this loops through that collection, and counts how many times each value shows up in hm_request_can_id
Is there a way to combine these two collections so that its 1 collection with 2 columns: status & count?
Solved! Go to Solution.
once again, you were spot on. the "1" worked and the updated formula worked.
Thank you, this helped me understand the mechanics of working with collections!
Excellent! Always happy to help.
User | Count |
---|---|
229 | |
99 | |
95 | |
56 | |
33 |
User | Count |
---|---|
280 | |
110 | |
109 | |
64 | |
62 |