Hello team, When displaying metrics as KPIs, none of the aggregation functions seem to care about the BY clause that is set. It just displays the total per selected period. When displaying the actual dimensions next to the calculated facts the aggregations do check out. Can anyone help me understand what might be wrong?

Hello Hans, if you slightly alter your metric definition to:

SELECT AVG(SELECT COUNT(Transaction id) BY Report id)

you should get your desired results on the KPIs.

Thank you Jan. That logic seems to stick.