I can think of a few options depending on the complexity of your data. The solutions can be as simply as using calculated fields with an IF then statement to produce the weights to creating a weights worksheet and blending it into your views.
Can you post a packaged workbook with some sample data and explain the weighting scheme?
Pedro, obrigada pela resposta .
O esquema de IF´s não me parece muito produtivo ... dá muito trabalho e não resolve.
O que procuro é uma função WEIGHT que possa ponderar qualquer sumarização (quantidades, médias, desvios, etc)
Seria muito útil pois nem sempre precisamos processar todos os dados para tirar uma conclusão.
No SPSS (básico) tem esta função e a TABLEAU poderia implementar (abriria um novo mercado – as empresas de pesquisa !!!
Pedro, thanks for the reply.
The IF´s idea does not seem very productive…very hard work (I did it).
What I am seeking is a function that can balance any WEIGHT summarization (amounts, averages, deviations, etc.)
It would be very helpful as we do not always need to process all data to draw a conclusion and samples can be stratified, for example.
SPSS (basic) has this function and TABLEAU could implement it (to open a new market – research companies).
Grata pela sua atenção e interesse.
Cláudia Mendes Nogueira
+55 11 32622504
+55 11 91096929
De: Pedro Machado
Enviada em: quinta-feira, 22 de agosto de 2013 13:54
Para: CLAUDIA MENDES NOGUEIRA
Assunto: Re: - How can I set a weight in Tableau to deal with samples ?
<http://community.tableau.com/?et=watches.email.thread> Tableau Support Community
How can I set a weight in Tableau to deal with samples ?
reply from Pedro Machado <http://community.tableau.com/people/pedromachado?et=watches.email.thread> in Forums - View the full discussion <http://community.tableau.com/message/223896?et=watches.email.thread#223896>
Are the weights available in your data file at the record level? Can you post some sample data to see if someone can come up with a solution?
Tableau doesn't have a native function to understand apply the weights, but you could probably write a calculated field to do it.
While this is less than ideal, it boils down to what features you need the most in order to decide which tool to use.
1 of 1 people found this helpful
I ran across a video that explains how to use Tableau with survey data:
It's based on an older version of Tableau, but the concepts are still applicable.
There is a discussion of weights starting at minute 13 or so.
Most of the latter part deals with re-shaping (transposing) the data for multiple choice questions.
It shows how to use the Tableau Excel Add-in to transpose the data, but you can do this in SAS or SPSS as well.
I hope this helps.
ex : Gender Like income weight 1 1 500 0.5 0 0 1000 0.5 0 1 200 0.5 1 1 399 0.5 0 1 230 0.5 0 1 440 0.5 1 1 220 0.5 0 0 1000 0.5 0 0 5000 0.5 1 0 2000 0.5 set weight on and all the analysis and statistics will consider it