Hi, I’m having trouble with looker when calculating averages. I have a very simple operation, where I have quantity of units sold in one column, and total sales value per item in another column. I just want to calculate the average unit price, but looker seems to be calculating something different. I even have the dats connected to looker, and plotted properly, and tried a calculated field but the result is just not what i am trying to calculate.
Can you explain more about why the calculated field isn’t working? Is the division not producing an expected result?