Consider the table below and assume that Table is your raw d…
Consider the table below and assume that Table is your raw data in Tableau. Look at it carefully. Suppose that you would like to calculate the average sales per order for each state. You drag State to Rows shelf and drag Total to Values (Columns shelf or Detail). Then change the calculation from Sum to Average. Will this give you the correct values?
Read DetailsConsider the two tables below and assume that Table 1 is you…
Consider the two tables below and assume that Table 1 is your raw data in Tableau. Table 2 is something you need. Look at both carefully. Table 1Table 2Suppose that you would like to do some analysis on the raw data but you will first need Table 2 to be created first in the memory and then used. How would you do this in Tableau?
Read DetailsConsider the two tables below and assume that Table 1 is you…
Consider the two tables below and assume that Table 1 is your raw data in Tableau. Table 2 is something you need. Look at both carefully. Table 1Table 2Suppose that you would like to do some analysis on the raw data but you will first need Table 2 to be created first in the memory. Which would be the right way to do this in Tableau?
Read DetailsConsider the table below and assume that Table is your raw d…
Consider the table below and assume that Table is your raw data in Tableau. Look at it carefully. Suppose that you would like to calculate the average sales per customer for each state. You drag State to Rows shelf and drag Total to Values (Columns shelf or Detail). Then change the calculation from Sum to Average. Will this give you the correct values?
Read Details