Hi everyone,
I have a question relating to the Insight Explorer and look forward to your help/ advice.
In the related Knowledge Model, I have defined a KPI called Rate of transferred calls - ID =percentage_of_transferred_calls, with this PQL formula:
KPI("count_of_transferred_call_segments")
/
KPI("count_of_calls")Unfortunately, this KPI does not come up on the list of Metrics that can be added to the Insight Explorer. If I search for its ID within the Insight Explorer configuration, I get the response:
No Metrics found
For additional context, count_of_transferred_call_segments has this PQL formula:
sum(
CASE
WHEN "ECHI_CASE_TABLE_Call_Data"."transferred" = '1'
AND "ECHI_CASE_TABLE_Call_Data"."disposition" = 2
AND "ECHI_CASE_TABLE_Call_Data"."outbound_call" = '0'
THEN 1
ELSE NULL
END
)While count_of_calls has this PQL formula:
SUM (
CASE
WHEN "ECHI_CASE_TABLE_Call_Data"."disposition" = 2
AND
"ECHI_CASE_TABLE_Call_Data"."outbound_call" = '0'
THEN 1
ELSE 0
END
)I’d really appreciate your help in resolving this issue. Thanks a lot.
Kind regards,
Vladimir