Forum Discussion
Measure as Values in Matrix
Hello, I have a data set from ITSM system with fileds including TicketID, Queue, Analyst, Type, Resolution Time in Bhrs (Minutes) and FCR (First Contact Resolution), Resolved Date. A measure ...
Hi MadhavDholakia - create a explicitly filters for the L2 as well as like below for last 13 months
FCR % L2 =
CALCULATE(
DIVIDE(
COUNTROWS(FILTER(Tickets, [FCR] = "Yes" && [Resolution Time in Bhrs] <= 30)),
COUNTROWS(FILTER(Tickets, [Type] = "Incident")),
0
),
Tickets[Queue] = "L2",
Tickets[Resolved Date] >= EDATE(TODAY(), -13)
)
calculate for L1 aswell seperately.
One for L1 queue and one for L2 queue.Rows and Columns: Add the Analyst to the rows and Resolved Date to the columns.Values: Use the newly created FCR % L1 and FCR % L2 measures in their respective visuals.