Did the way we're supposed to do rolling window fu...
# gooddata-cloud
m
Did the way we're supposed to do rolling window functions change? Our formulas had been working, but now are incorrect. Specifically, when we do
select 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.
j
Hi Michael, did anything change in the configuration of the graph? There should be a little check box to show missing values, did this get changed perhaps?
m
Nope, that's checked. You can even see it's showing those dates w/o data as 0 if you zoom in. This feels like a regression.
j
Yes, certainly doesn't look good. Please let us double-check this behavior with our engineers.
👍 1
Hi Michael, Maybe we could take a look at how this is configured in your enviornment? Could you please DM me a direct link to the visualization here so we can investigate this in our support team?
m
DM Sent.