Hi all,
I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have-
SUM(COUNT(TicketNbr
)) OVER (PARTITION BY Board_Name
ORDER BY last_update
)/ DAYOFMONTH( last_update )
But I think the calculations are off. Is there something that I need to change, I can't quite figure it out.
Any assistance is greatly appreciated.