Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thanks.
May be this:
Count({$+<[Assigned team] = p([Orginiate team])>}Tickets)