-
1. Re: Get the average of a field - weighted to the population
Jim DehnerJun 25, 2018 1:33 PM (in response to Dustin Greelis)
Hi
Not sure I understand your example but see the attached
I interpreted the problem as Q1 is already the weighted product of the answer and the number of respondents (weight)
and you wanted the avg response or the unweighted response
if that isn't what you wanted please clarify
thanks
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.
-
Weighted_Average_v10.2.twbx 21.0 KB
-
-
2. Re: Get the average of a field - weighted to the population
Dustin Greelis Jun 25, 2018 1:46 PM (in response to Jim Dehner)Hi Jim,
Thank you for going through all the time responding to this with an example. Unfortunately, this isn't what I was going for. The responses you see in Q1 are unweighted. So in the datafile, they only count as 1 response right now, and that's how Tableau reads it in to the charts/graphs. I'm looking to have each response count for the number of responses that are in the weight column.
For example:
In the first row, the response to Q1 is 260.33, and the weight is 6. I'm looking to essentially have Tableau count that 260.33 six times, and repeat the operation of counting each Q1 response by the number in the weight. Then, apply an average to all those numbers. So in the average calculation, the 260.33 would be counted 6 times.
It's kind of a tough thing to explain, so please let me know if you'd like me to elaborate.
Thanks again,
-Dustin
-
3. Re: Get the average of a field - weighted to the population
Jim DehnerJun 25, 2018 2:35 PM (in response to Dustin Greelis)
1 of 1 people found this helpfulsee the attached
it returns this
in table form
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.
-
4. Re: Get the average of a field - weighted to the population
Dustin Greelis Jun 26, 2018 6:29 AM (in response to Jim Dehner)Thank you Jim! The result in the AGG(avg per year) line is exactly what I was looking for! I really appreciate your time and help.