i am facing an issue, i heave date pickers and two list boxes like as below.
Originate team
ABC india
ABC singapore
cs india
xyz
Assigned team
ABC india
MNO corp
xyz ltd
abc singapore
KLM Prod
Issue: usually tickets are assigned to aaigned team and orinating by orginating team most of the tickets are handled by originating team.
but few tickets are handled by assigned team.
EXAMPLE: if i have 100 tickets assignd to ABC india and in that 90 tickets are handled by ABC india in originating team. remaining 10 tickets are handled by abc singapore.
Problem: i have given date range and when i select ABC india(Originating team) it is giving 90 tickets. but actual tickets are 100.
when i select ABC india i need count 100 how can i get please help me.