フリー問題

問題文

A view shows sales by region, and the client wants the average order value computed per customer before it is averaged for the region. Which expression shape fits?

選択肢

1. A fixed level of detail expression on the region, which pins the region as the grain of the whole computation.
2. An exclude level of detail expression on the customer, which drops the customer from the grain of the outer computation.
3. A total level of detail expression on the table, which uses the table as the grain of the final computation.
4. An include level of detail expression on the customer, which adds the customer to the grain of the inner computation.