Good day,
I have a beast mode calculation that I believe can calculate the sum of accidents over the previous 12 months for any given month. My data set goes back 3 years on a month by month basis. Here is the current beast mode that works when I validate it:
SUM(SUM(fieldsAccident Count
)) OVER (
PARTITION BY YEAR(fieldsMonth Ending Date
)
ORDER BY fieldsMonth Ending Date
ROWS BETWEEN 11 PRECEDING AND CURRENT ROW
)
However, when trying to insert the beast mode into any visual/card, I get the following message in the Analyzer:
An issue has occurred during processing. We are unable to complete the request at this time.
What is potentially wrong with my beast mode and what can I do to fix it?