Hello,
I was hoping to find a way to take the MAX, MIN, and AVG of a calculation based on a column in a beast mode calculation. For example, I am creating the "Average Performer" as something like the below query but I am getting an error thrown.
AVG(AVG((SUM(COMPLETED
) / SUM(EXPECTED
))) FIXED (BY GROUP_1
))
I was basing my work on this link:
https://domo-support.domo.com/s/article/4408174643607?language=en_US
. Does anyone have any suggestions on what I can do?