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:

3

@David_Wong …This was a useful pointer as I ran into a similar requirement and this helped me find the answer to my question