Please attach sample workbook. What you are doing is a general procedure but varies from case to case, so attach workbook only to help you.
Dashboard has been attached.
Here few points on which I need assistance
I . Met# = if [case created]>=3 then 1 else 0 end, but the grand total is incorrect.
II. Missed# = if [case created]<3 then 1 else 0 end, but the grand total is incorrect.
So it goes to the incorrect grand total of compliance% as well.
would appreciate if anyone from the forum comes up with a solution.
Dashboard.twbx 21.8 KB