Expression Help - First Solver for FCR
Content
I'm working on a FCR report.
I have created a Custom Incident Field called FCR that changes from Yes, to No, once an incident is Updated.
What I am trying to build this report
- Column 1: Account of First Solver
- First(transactions.acct,transactions.created)
- Column 2: Count of FCR=Yes for incidents solved by First Solver (incidents only solved once)
- Count(If(Incidents.c$FSR=1,transactions.created))
- Column 3: Count of FCR=No for incidents solved by First Solver (incidents updated)
- Count(If(Incidents.c$FSR=0,transactions.created))
My challenge is with the Column 1. When I use "First(transactions.acct,transactions.created)" I only ever get 1 account. Which makes sense, I'm seeing the first account for the first transaction within my date range.
Tagged:
0