the table at the top should be counting the related units (which are in a separate collection in the db), in the list below and instead it is counting them all as the same amount.
The table in this case should read:
EAD - 1 (this is the purple icon with the paint board)
PD - 3 (this is the red dancing man)
MATH - 1 (this the yellow icon with the + - etc)
I would think that this will require some kind of custom equation, if it is even at all possible!
lol, faced the same problem trying to set up a Chart, could not figure it out in this chart compo.
if you re only interested in differenciating sums of each in this compo…I cant help.
else… I could dif the SUM fo each in Custom Lists…you just need to use a custom list for each category EAD/PD, etc…and display them one above the other…
I beleive Adalo is missing a MINI TABLE GRID system that could display them all in a compact “MINI excell Sheet” format with numbers and Icon support.