Doug Creighton
08/18/2023, 6:04 PMselect avg({fact/case_duration})
where {fact/analyze_case_clicked} = 1
and {fact/smart_response_exported} = 0
I'm trying to View BY Message "Smart Response Intent" which is an Text metric
When I add Average Handle time to as a bar graph. I can not select Smart Response Intent for view by. I can select other ones such as user but not that one.
Why is that? What is the work around?Michael Ullock
08/18/2023, 6:23 PMDoug Creighton
08/18/2023, 6:31 PMDoug Creighton
08/18/2023, 7:13 PMMichael Ullock
08/18/2023, 7:16 PMDoug Creighton
08/18/2023, 7:17 PMDoug Creighton
08/18/2023, 7:18 PMDoug Creighton
08/18/2023, 7:38 PMDoug Creighton
08/18/2023, 7:39 PMMichal Hauzírek
08/18/2023, 7:40 PMSELECT AVG(Fact 1)
and use it with attributes 1 and 2 (and that works) and with attributes 3 and 4 and that does not work?
Is that your setup? Or does it look differently?
Also if this is the case, what is the cardinality between rows in Table 1 and Table 2 in your database? Can there be multiple rows in Table 2 which have the same “Case interaction ID”? Or is it 1:1 relationship?Doug Creighton
08/18/2023, 7:40 PMDoug Creighton
08/18/2023, 7:44 PMMichal Hauzírek
08/18/2023, 9:06 PM