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))
![RK121_0-1666191704770.png RK121_0-1666191704770.png](https://community.qlik.com/t5/image/serverpage/image-id/91697iE1EE8F6E9EC9EE85/image-size/medium?v=v2&px=400)