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 Details