Solved: Access average of a column in calculated fields - Page 2

HerculesVent · 06-21-2024 03:37 AM

I have this table that shows the data from a dataset in google sheets. Now, what i want to do is make an extra column on this table, that basically does this:
If the helps of the user are above the average of all the user's help, the field shows "1", otherwise, it shows 0. I have tried to do this myself but i can just not get it to work. Any help is appreciated. Thanks!

lauratilton

Put all your fields in the first table of the blend. In the second table of the blend just put the Helps metric, with AVG aggregation. Choose cross join and rename Helps to Overall Helps Avg for that second table.

That will give you a blended data source that contains all your fields plus the Overall Helps Avg field. If you want to use it in a calculation you’ll need to create a calc field at the chart level, not the data source level.

View solution in original post