AnsweredAssumed Answered

Possible bug: Matrix reports broken in

Question asked by Francesca Shiekh on May 12, 2016
Latest reply on Jul 1, 2016 by Alex Nassi

Does anyone else have issues with matrix reports in


Matrix report

Module: Calls


Calls > Date Created [This Year]

Group By:

Calls > Assigned User > username

Calls > Direction

Display Summary

Calls > Assigned User > username

Calls > Direction

Calls > Count


No Chart options

No Optional Related Modules


Show SQL:

SELECT l1.user_name l1_user_name,IFNULL(calls.direction,'') calls_direction

,COUNT( calls__allcount, COUNT(DISTINCT calls__count

FROM calls

INNER JOIN users l1 ON AND l1.deleted=0

WHERE (((calls.date_entered >= '2016-01-01 07:00:00' AND calls.date_entered <= '2017-01-01 06:59:59'


AND calls.deleted=0

GROUP BY l1.user_name


ORDER BY l1_user_name

ASC,CASE WHEN calls.direction='Inbound' THEN 0

WHEN calls.direction='Outbound' THEN 1 ELSE 2 END ASC


In MySQL Workbench select works fine, in output the username is not present in all rows and totals seem off.