To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:
Dimensions and Measures, Blue and Green - Tableau
Tableau Certified Data Analyst Study Guide
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