LAC-W function requires visuals to group by the aggregate field

Question & Answer
,
1

expectation: on visual, I shouldnt group by ColA but If i dont i receive an error “missing reference”. I want to count ColA in the LAC-W function and dont want to group by that field in visual

countover({ColA}, [{ColB}, {ColC}])

2

Hi @Hussein_Labib,

If you don’t specify PRE_AGG or PRE_FILTER as calculation level, all the fields in your calculated field have to be included in your visual.

countover({ColA}, [{ColB}, {ColC}], PRE_AGG) should work for you in most cases. In some cases you will need PRE_FILTER instead of PRE_AGG.

You can read about the differences here: