Download All Practice Quizzes
Including step-by-step solutions.
Certified Associate Practice Quizzes
Specialist Practice Quizzes
Online Courses
Our online Tableau courses can help you get certified as a Qualified Associate or Tableau Specialist.
Accelerate your Career and Get Certified
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.