Stack pre-filter doesn't work with standard variable
Hello everyone,
Hope you're doing well
I am trying to use a pre-filter in the stack recipe using SQL as computation engine but it doesn't work.
Here is the formula and the error :
It is weird because the same formula works in a pre-filter in the distinct recipe.
Do you have any idea how to do this ?
Thank's in advance
Kenza
Best Answer
-
Hi Kenza,
Yes, this is very strange indeed!
I was able to reproduce the error, and also found that it occurs in the pre-filtering of the Split recipe. On the other hand, the formula works as expected in the pre-filtering of all other visual recipes.
The issue seems to be caused by the variable substitution of ${date_max_last_month}, as the recipe runs successfully if I use a hard-coded date instead.
I am tempted to say that there is a bug related to the parsing of DSS formulas within the pre-filtering of the Split and Stack recipes, but I need to confirm with our R&D team.
In the meantime, a workaround to your issue would be to use a Filter recipe before the Stack recipe. I have tested your formula there, and it works as expected.
Thank you for bringing this to our attention
Have a great weekend! Ned