Accelerate your Career and Get Certified
Answer these questions using the Superstore sample data.
Be sure to click Submit Quiz to see your results!
Time is Up!
Thanks, that worked for me. Learnt a new function in the process.
How was Q2 calculated?
To get the average sales per category, you can do total(sales)/countd(sub-categories). If the total sales is 10 million and there are 10 categories, then the average per category is 10/10 or 1 million.
The aggregations still have to be fixed though in order to make them the overall average sales PER all sub-categories instead of average sales IN each sub-category since you need to display the product sub-categories. It’s a slight distinction but it makes a huge difference in the calculation. Alternatively, you could do a WINDOW_AVG on the sum of Sales to get the same result.
Your email address will not be published. Required fields are marked *
Notify me of follow-up comments by email.
Notify me of new posts by email.
Including step-by-step solutions.
Get All Quizzes
Our online Tableau courses can help you get certified as a Qualified Associate or Tableau Specialist.