Forum Discussion
Calculate Average Based on Two Categories
I have two tables-- One with category types and one facts table that includes values. I want to calculate a column with the average of the values in the facts table based on two categories in the ot...
I used the above function and received this error:
The AVERAGE function only accepts a column reference as an argument.
Selva-Salimi
Solution Sage
Solution SageAnonymous
as I said before, _visitpercapita is the name of column you calculated in the previous step.
in the image you shared the name is [filtered visit per capita], so replace it!