
1. Re: LOD calculation to count the # of responses in a set
Deepak Rai Jun 25, 2019 11:44 AM (in response to Bryan Mills)1 of 1 people found this helpfulYou may have alook here at Exaple 1:

2. Re: LOD calculation to count the # of responses in a set
Ewald Hofman Jun 25, 2019 11:49 AM (in response to Bryan Mills)You can use this LOD
{FIXED [Respondent Id] : sum(if LOWER([YesNo Answer]) = "yes" then 1 end)}
Although in your dataset, there are much more questions than just 10 per respondent

Tableau forum workbook.twbx 87.3 KB


3. Re: LOD calculation to count the # of responses in a set
Bryan Mills Jun 25, 2019 12:03 PM (in response to Deepak Rai)Thank you for this, Deepak and Ewald. I think this is getting me close to what I need. There's a bit more complexity to my datasource that adds a little wrinkle but I will play with the concepts you both shared and see if I can get it to work. Thanks!

4. Re: LOD calculation to count the # of responses in a set
Bryan Mills Jun 25, 2019 12:06 PM (in response to Ewald Hofman)It looks like if I add the set of questions I am looking at to a context filter it will take care of this and perform all the calculations on just the 10 questions in the set. Getting closer!

5. Re: LOD calculation to count the # of responses in a set
Jim Dehner Jun 25, 2019 12:26 PM (in response to Bryan Mills)1 of 1 people found this helpfulHi Bryan
see the attached
it returns this
then binned the result
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

6. Re: LOD calculation to count the # of responses in a set
Bryan Mills Jun 26, 2019 8:02 AM (in response to Jim Dehner)Thanks, Jim. I ended up using this solution tweaked just slightly for how my actual datasource has everything set up and hadn't thought to use a binned result, which ended up working nicely!

7. Re: LOD calculation to count the # of responses in a set
Jim Dehner Jun 26, 2019 8:04 AM (in response to Bryan Mills)Glad to help out
I was a little confused about how the data  question  response thing worked  not my field
Jim