Finding the average of one value where another value is X

[Anonymous]

Hello

I am trying to form a bar chart with the average of field A where Field B = 1

What would be the expression for that

Thank you

[Gysbert_Wassenaar]

avg({<[field B]={1}>} [field A])