Revenue and Quantity are the two quantitative fields that must be measured to calculate average revenue per item. The analyst can derive the required business metric by relating the monetary Revenue measure to the Quantity measure, such as revenue divided by units sold at the appropriate aggregation level. Customer Region is required to segment the analysis geographically, but it is a dimension rather than the numeric value being measured. Order Date provides the time dimension for analysing the metric over time, and Product Name can further categorise the data, but neither is the primary quantitative measure required by the question. Tableau defines measures as quantitative fields that can be numerically aggregated, while dimensions are qualitative fields used to group or segment the data. Therefore, Revenue and Quantity are the appropriate selections.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit