I think that you are close. The following formula might work better for what you're going for:
IF CONTAINS (attr([RESULT]), "success") THEN count([RESULT]) END
Then, create another one for Failure.
If this doesn't help, would it be possible to post a packaged workbook and give a little more detail about the desired outcome?
Thanks Tracy for responding, but the calc didn't work. My desired outcome is:
- Create separate success and failure measures
- That way i can create success/failure % (goal success/goal count)
Right know i can only see this breakdown if i create groups from the results dimension. I attached a packaged workbook.
Sample Data.twbx 277.9 KB