1 of 1 people found this helpful
I think all we need to do is just modify the formula used for the [last 3 weeks] filter to use this:
LOOKUP(MIN([Order Date]), 0)>(DATETRUNC('week',TODAY())-22)
By filtering with a table calc (the LOOKUP function) we are able to "filter" out the rows but still allow the WINDOW_AVG calc to reference them. Table calc filters act more like hiding the rows instead of completely filtering them from the view.
How does this look?
Thank you very much.
Just 1 more thing... can we also have the no: of reds and greens for each row.