Question

Need to calculate a column average - please help!

  • 26 April 2022
  • 1 reply
  • 31 views

End Goal: Compare Q4 rep averages to Q1 rep averages in 3 specific columns. 

 

This seems like it should be so simple - I have a bunch of columns, and just need to calculate a single column average. The only workaround I’ve found is to export everything and calculate in excel, but I’ve been asked to use Looker instead of excel.

 

Have poured through videos and community articles - THIS was the closest match I found, but when I tried to use the suggested sum(${parts_cost_per_visit})/count(${parts_cost_per_visit}) it just kept giving me an error message.

 

Please help! This has sucked HOURS of my day :(


1 reply

if you are just trying to average a single column/dimension, and have access to LookML development, you should just be able to use an “average measure”: https://docs.looker.com/reference/field-reference/measure-type-reference#average

Reply