As can be seen from image, i have calculated whole month productivity for all agents with respect to unique date and time for each
The logic used is:
if same ticket(incident number) worked by same agent on single day, the productivity for agent will be one even if u enter same ticket for same date multiple times.(logic already impleted)
If same ticket worked by same agent on another day then the productivity will be counted as 1 for next day so total productivity for 2 days will be 2
This is how it is reflecting in F column under count... All data(productivity) is shown for entire month using formula under count "=IF(E6="",0,COUNTA(UNIQUE(FILTER(B$6:B$100000&"|"&C$6:C$100000,E$6:E$100000=E6,0)))) "
but now i need to filter on single day basis for each agent, In the above it shows unique values for whole month for each user . please help. nee to submit this by tomorrow
eg: for fathima under I column it has to show 1 under 1st may again 1 under 2nd may (im getting result for both days as 2 under F for whole month)
likewise for for Ameena it has to show 1 under 2nd may
The logic used is:
if same ticket(incident number) worked by same agent on single day, the productivity for agent will be one even if u enter same ticket for same date multiple times.(logic already impleted)
If same ticket worked by same agent on another day then the productivity will be counted as 1 for next day so total productivity for 2 days will be 2
This is how it is reflecting in F column under count... All data(productivity) is shown for entire month using formula under count "=IF(E6="",0,COUNTA(UNIQUE(FILTER(B$6:B$100000&"|"&C$6:C$100000,E$6:E$100000=E6,0)))) "
but now i need to filter on single day basis for each agent, In the above it shows unique values for whole month for each user . please help. nee to submit this by tomorrow
eg: for fathima under I column it has to show 1 under 1st may again 1 under 2nd may (im getting result for both days as 2 under F for whole month)
likewise for for Ameena it has to show 1 under 2nd may