Hello! I didn’t find anything like this in other topics, but I really need to count average with zeros.
F.ex. I have numbers 22, 22, 0, 44, 0. Type of measure “average” usually ignores zeros and basically counts 88/3. But what I need to do, it’s 88/5. I need to do this in LookML. Any ideas, please?