Michael DeWulf
11/22/2024, 6:24 PMselect runavg(Total Leads) rows between 8 preceding and 1 preceding with pf except *Timestamp - Date*
for the previous 7 days (view by timestamp at day granularity), the data is incorrect when we have date ranges w/o data, even though we define Total Leads = select ifnull(Total Forms + Total Clicks to Call, 0)
(there are similar ifnull
guards on "Total Forms" and "Total Clicks".
Here is the raw data, and the "running 7 day average". Note how the average no longer dips below 0 when there is missing data. It used to.Joseph Heun
11/22/2024, 6:38 PMMichael DeWulf
11/22/2024, 6:40 PMJoseph Heun
11/22/2024, 6:41 PMJoseph Heun
11/22/2024, 7:40 PMMichael DeWulf
11/24/2024, 2:34 PM