Once you have the data inside Tableau, you can write calculations using the weight field. That would look something like
[FieldName] * [Weight]
If the weight is only applied under certain conditions, you can evaluate those as well--something like:
IF [Age] > 50 then [FieldName] * [Weight]
Hope this helps. If you get that data into Tableau and are trying to set up a view, post a packaged workbook (.twbx file with the data extracted) here on the forum, along with what you are hoping to achieve, and forum members are happy to contribute.
Awesome! I'm sure this will be a huge help. I'll post my workbook for sure.
Thanks a lot.
On Tue, Oct 29, 2013 at 10:41 AM, Matthew Lutton <
Data set link: Dropbox - cell.twbx
So...I'm trying to create a calculated field using the weighted data column (weight). For a simple example, I'm trying to make a histogram of Q1. The answers to the question are 1,2,3,4,5,8,9.
Making simple histogram works with the unweighted Q1 column.
Now if someone could help me weight this using the "weight" column I'd be very happy
To obtain the weighted results for every question we need to create a calculated field (in my solution this new calculated field is called Weighted Number of records) using the formula:
[Number of Records]*[weight]
In this type of analysis we need to determine the frequency of specific responses from every person in the survey. This means that we need to count the number of person (number of records) in every possible response values of a question. As we need the weighted frequencies, we need to calculate number of persons times weight.
See the attached workbook. The dashboard shows Question 1 (q1) results, both unweighted and weighted
I hope this helps,
cell_RM.twbx 187.1 KB
Ok...let's say I wanted to show the relationship between users of specific cell phones (Q15) and their quality of life (Q1). For example: "What percent of each type of cell phone user has each quality of life?" How would I make a stacked bar chart showing that, while calculating in the weight as well?
If any of you genius stats people out there can help me out I'll be so grateful!
I need to perform other calculations like this, so once I know the formula for doing so I can knock this stuff out. Thanks again!!
Take a look at the attached workbook. See the new worksheets: q15 vs q1 weighted absolute numbers, q15 vs q1 weighted % and stacked bar q15 vs q1
I also recommend you to read the blog post series Visualizing Survey Data by Steve Wexler
I hope this helps,
cell_RM_v2.twbx 224.3 KB
I haven't had a chance to, but I will be checking it out later tonight. I'll let you know if I have any additional questions. Thank you so much!
On Wed, Nov 13, 2013 at 7:47 AM, Ramon Martinez