AZaiter Member

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 should allow it to divide the 12 month rolling sum by month in a line graph. For…

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 elaborate more on beast mode window function enabling? Not sure what that is,…

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 PRECEDING AND CURRENT ROW ) Unfortunately, I am still getting that general…

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 example, if the sum of all accidents from June 2022 - June 2023 is 100 accidents,…

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.

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 display the sum of all accidents from May 2022-May 2023, etc. The idea is to…