could you please attach packaged workbook (.twbx) file to explore your scenario with data?
or attach sample .csv or .xls file.
In the future others will find it helpful if you use a packaged workbook, rather than a regular workbook. The package workbook will include the data used in the workbook. Otherwise, when we open a regular workbook we receive an error.
Even without that I think I understand your issue. I don't think you are over complicating it. For me, it is easiest to work through the calculation step wise. There are some short cuts you will learn and you use the product, as well.
Step 1 - Create a calculation for each 'Check' dimension that counts or sums the instances of 'Yes'. You'll end up with 3 calculations.
Step 2 - Create a calculation which adds these 3 calculations together.
You can wrap them all into one calculation, if you like. Or you can drag and drop the measures into the measure value shelf and write the calculation there.
I've attached a packaged workbook with a sample.
Also, here is an article about writing ad hoc calculations in the measure values shelf. 10 Things you didn’t know about Ad-Hoc Calculations in Tableau 9 – VizPainter
Example.twbx 13.2 KB
Thanks Sunil, I thought I did that but I didn't realise it had to be a packaged workbook! I will do that for my future posts.
Thanks Catherine, this has answered my question! Thanks for the details on packaged workbooks as well.