Set Analysis (Monthly AVG)

[RK121]

Hello, I am new to QlikSense.

Could you help me fix my set analysis script. I have a list of employees who work on a different shift, I need to calculate the average number of solved Tickets by Ticket Action and by shift worker.

Basically, this is the performance of an employee against his shift.

My formula:

=Avg(Aggr(count({<[Full Month (YYYY-MM)] = {"$(=Date(AddMonths(Max(Today()),-1), 'YYYY-MM'))"}, User=>} ([Trouble Ticket ID])),[Ticket Action], Shift))
/
num(Month(now()-1))