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.

Why ticket count is not an integer?

Discussion in 'Kayako reports (Kayako Classic)' started by Cuong Le, May 18, 2012.

  1. Cuong Le

    Cuong Le Member

    I have the following query

    SELECT COUNT('Tickets.Ticket Mask ID') AS Total FROM 'Tickets', 'Users' WHERE 'Tickets.Creation Date' >= mktime(0,0,0,1,1,2012) AND 'Tickets.Creation Date' <= mktime(0,0,0,11,4,2012) GROUP BY 'Users.User Organization'

    the report output with a nice chart. However, on the Y axis, it shows scales of 0 - 20.24 - 40.48 - 60.72 - 80.96 and 101.2. Why the ticket count is displayed in decimals?
  2. masterctrl1

    masterctrl1 Kayako Guru

    The Y-axis issue exists for all the reports. This need to be fixed in a future edition so Y values are "normalized" in all cases.
    Another example is entries like 19.74, 38.75 and 59.36 insteasd of 20, 40, 60 seconds.
  3. Drew Keller

    Drew Keller Just one person in a world of millions.

    Just upgraded to get 4.40.1148 and saw this and yes very annoying.
  4. Andriy Lesyuk

    Andriy Lesyuk Developer

Share This Page