Comments
-
@ColemenWilson - the below beast mode calculation is not giving me an error but when I insert into the table, I get an error "An issue has occurred during processing. We are unable to complete the request at this time - 'undefined' " ( SUM(SSI Monthly) + LAG(SUM(SSI Monthly), 11) OVER (ORDER BY Incident Date (Year-Month))…
-
Was there a solution to this? I am also trying to view the below in a table. Month Monthly Count Rolling 12 Month Count Comment Oct-24 5 71 Oct-24 to Nov-23 Sep-24 6 71 Sep-224 to Oct-23 Aug-24 11 69 Aug-24 to Sep-23 Jul-24 7 66 Jun-24 9 63 May-24 2 54 Apr-24 3 52 Mar-24 9 49 Feb-24 4 40 Jan-24 6 36 Dec-23 1 30 Nov-23 8 29…