crispinvaldez Member

Thank you Jae, this was what I was looking for. My entire question was 1, can I do all three in one transform, then 2 how but I was able to find it with your explanation. I currently have a Google sheet feeding in Sales quotas then joining that to Sales actuals but I want to create that table in Domo to avoid having it…

If you are using Redshift, I was able to fix this using "::decimal(16,8)" the first number is the precision and the second one is the scale or how many numbers right of the decimal. 

Thank you so much!! It was that simple. That worked!

I am not sure why its not working and I know window functions are turned on. lag(SUM(`Cost`)) over (order by YEAR(`Date`) * 100 + WEEKOFYEAR(`Date`))

No worries Jae! I did try it and I am getting the same error Jason is above. I actually got a reply from the Domo support team and they told me they have never been part of beast modes. I will continue trying and trialing it. I agree that Google is an excellent research tool for things like this. That's actually how I…

Hello, Have the lead and lag functions been turned off since this post? I am being told we have window functions on but lead and lag are not working.