Hi All,
I am getting “VISUAL_CALC_REFERENCE_MISSING” error when trying to add one calculated field having AvgOver function and in that using two dimensions(avgOver(sum(Sales),[Customer,Region])), among which even if including both dimensions in the visual i am getting error when pulling the calculated field in the visual.
I have mentioned the dashboard link below, kindly look into it and help me out.
Question
Sincerely,
Arpit Arora
LAC-W formulas require the fields in the group by to be in the visual. Switch to LAC-A to not require that.
avg(sum(Sales, [customer, region])
thank you for being a member of the Quick Sight community!!
Hi Ramon,
Thank you for your reply but the formula you have provided is throwing error. Can you please recheck and provide the correct formula? Thanks!
sure- its missing a parenthesis at the end.
laca
1 Like
Thanks Ramon! that worked.
2 Likes