Hi!
I'm having trouble trying to modify this list of maps (which I get from a!queryRecordType with an aggregation).
local!Grades: {a!map(Group: "A", Excellent: 0, Good: 0, Regular: 0),a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 0, Regular: 2),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 0),a!map(Group: "C", Excellent: 0, Good: 2, Regular: 0),},
The aggregation does not allow me to get each Group in only 1 row, because I need to "count" the grades by category (Excellent, Good, Regular)
I would like to display that result in a read-only grid and am trying to prepare the data before displaying it there (as I read in some other suggestions).
The result I am trying to obtain is this:
local!Grades: {a!map(Group: "A", Excellent: 2, Good: 0, Regular: 0),a!map(Group: "B", Excellent: 0, Good: 2, Regular: 2),a!map(Group: "C", Excellent: 0, Good: 2, Regular: 0),},
In other words, I want to match each row of the grid to each group, and the columns will be: "Excellent", "Good", "Regular".
I tried using 2 nested foreach... but it doesn't work.
Please, help me with some ideas!
Thank you in advance!
Discussion posts and replies are publicly visible
You can use group by group or try using where contains function.
Thank you for your replied!