is there a way to show avg in the subtotal portion in a calculated metric column?
in the image, in % column, is computed as: (sum(totalProd) / (sum(duration) / 3600)) / avg(hourlyGoal), which is technically avg units / hourlyGoal
avg units and % are both calculated metric in the table.
I have already tried blending and other stuff that I have seen in the internet, but I am failed to get my desired results, anyone can help me with this?
Sample dashboard: https://lookerstudio.google.com/u/0/reporting/86d1255e-0db7-40d2-93de-9701228e9d9a/page/QDIHE/edit
source data file: https://docs.google.com/spreadsheets/d/1ApoPyrDEN7ys1eraL5DGFJjkKI7W0c2243X6KrTNjp0/edit?gid=0#gid=0