1. Kayako Download customers: we will continue to develop and support Kayako Download beyond July 2017, alongside the new Kayako for existing customers.

    Find out more.

  2. The forum you are viewing relates to Kayako Classic. If you signed up or upgraded to the new Kayako (after the 4th July 2016), the information in this thread may not apply to you. You can visit the forums for the new Kayako here.

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

Discussion in 'Kayako reports (Kayako Classic)' 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:
    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?
  2. Andriy Lesyuk

    Andriy Lesyuk Developer

    Neither is available for now, sorry.

Share This Page