Comments
-
Although it's been a while since this was addressed, for the sake of others searching for an answer to the same question, there is a way to do this. A detailed thread about this can be found at the Dojo post below: User-defined variables in SQL queries/transformation — Dojo Community (domo.com)
-
@MarkSnodgrass , Thank you for the corroboration. This was my expected direction after bringing the dimensions online. I think that @GrantSmith was also going this way. It's a lot of records but to get a 30 day history record by record, it's what we have to do. Thanks to @jaeW_at_Onyx as well, the conversation was very…
-
@jaeW_at_Onyx I fear I may be misunderstanding this. My lag isn't from the current date. My lag needs to use the date on each record as its fixed point. For each SKU, for each date, on each transaction, I need to go back 30 days from that point to get my numbers. To me, that means cartesian, as ugly as that will be. A left…
-
@GrantSmith I looking for 30 days from the date of the row.