AZaiter Member

https://community-forums.domo.com/main/discussion/comment/69271#Comment_69271 We might ultimately have to do that, but still not sure why the Beast Mode functions you guys provided are not running, unless the only logical reason is related to window functions. It's a pretty basic calculation I am trying to make and Domo…

https://community-forums.domo.com/main/discussion/comment/69269#Comment_69269 Adding in the outer sum function was approved but still getting the error when inserting into a visual: SUM(SUM(fieldsAccident Count)) OVER ( ORDER BY LAST_DAY(fieldsMonth Ending Date) ROWS BETWEEN 11 PRECEDING AND CURRENT ROW ) Can you please…

https://community-forums.domo.com/main/discussion/comment/69248#Comment_69248 Thanks for the help. I think we are getting closer but something is still off. Removing the partition clause in the beast mode, It currently is looking like this: SUM(fieldsAccident Count) OVER ( ORDER BY fieldsMonth Ending Date ROWS BETWEEN 11…

https://community-forums.domo.com/main/discussion/comment/69238#Comment_69238 Ultimately on a line graph. So basically a line graph that has the last 12 months (June 2022 - June 2023) on the X axis and each point for each month on the line graph is the sum of each month's accidents over the previous 12 months. So for…

https://community-forums.domo.com/main/discussion/comment/69229#Comment_69229 Thank you for this. The beast mode was approved but unfortunately I am getting this same error when trying to insert into a table or graph. Still not sure why.

https://community-forums.domo.com/main/discussion/comment/69108#Comment_69108 Your formula works but I don't think it accomplished what I am trying to do. If right now it is June 2023, I want my most recent data point calculated to be the sum of all accidents from June 2022-June 2023. Right under that for May 2023, it will…