I’m facing the following issue:
I have a couple of stores and a depot. I want to calculate how much rent I pay per package for the stores and for depot. Additionally, I want to see how much total rent I pay per package that went throught the depot. It’s supposed to be something like:
When I try to accomplish this in Looker, I setted
rent/min(items_sold)and was expecting Looker to just sum both outputed values, but it’s displayed the global average. Can someone, please, explain?
Thanks in advance.