Maria Ahmed
03/26/2025, 7:29 AMSELECT SUM({fact/FactDonationIncome.Amount})/COUNT({label/FactDonationIncome.Id})
WHERE {label/FactDonationIncome.FactStatusKey} ="1"
but the value for the average donation doesn't change when the date range is changed. How can I make it so that the value of average is calculated according to the date range? As you can see in the metric, the total is divided by the count of the Id since a single donation is kept in multiple rows in our system so using the default average aggregation on the headline would make it inaccurate. This is a bit of an urgent issue.Joseph Heun
03/26/2025, 7:51 AMMaria Ahmed
03/26/2025, 7:56 AMJoseph Heun
03/26/2025, 8:06 AMMaria Ahmed
03/26/2025, 8:07 AM