5 Replies Latest reply on Aug 27, 2013 11:33 AM by CLAUDIA MENDES NOGUEIRA

# How can I set a weight in Tableau to deal with samples ?

I need use a weight to make the analysis correct in tableau.

Like we use in SPSS or SAS.

• ###### 1. Re: How can I set a weight in Tableau to deal with samples ?

Claudia,

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

• ###### 2. Re: How can I set a weight in Tableau to deal with samples ?

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 !!!

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

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 ?

How can I set a weight in Tableau to deal with samples ?

• ###### 3. Re: How can I set a weight in Tableau to deal with samples ?

Oi Claudia.

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.

Pedro

• ###### 4. Re: How can I set a weight in Tableau to deal with samples ?

Claudia,

I ran across a video that explains how to use Tableau with survey data:

Survey Data and Tableau | Tableau Software

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.

Pedro

1 of 1 people found this helpful
• ###### 5. Re: How can I set a weight in Tableau to deal with samples ?

 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