Hello all,
I am hereby attaching my sample app and request you all to suggest an expression to count the defects month-wise. Also count should not be done for repetitive defect IDs in different years. Tricky part is , there is a master calendar but not linked to the table. I already created two different posts (1 for master calendar and 1 for count). If my master calendar type is wrong , please help me in choosing correct type.
NOTE: Other dashboard tables are linked via master calendar which are not in this sample. So I can't avoid the master calendar at all.
Thanks,
Jamy