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