Looking for a way to Total a Column/Row in reports

Discussion in 'Kayako Reports' started by esowers, Jul 11, 2012.

  1. esowers

    esowers Established Member

    I have a report, but I'd like to add a row at the bottom to represent the total numbers of a column. Does anyone know if this is possible?

    Here is the report:
    Code:
    SELECT COUNT(*) AS Total FROM 'Tickets' GROUP BY X('Tickets.Department', 'Tickets.Status')
    Also, is there a way to center the numbers under the department's title?
    ticket_by_dept.jpg
     
  2. Andriy Lesyuk

    Andriy Lesyuk Developer

    Neither is available for now, sorry.
     

Share This Page