Why ticket count is not an integer?

Discussion in 'Kayako Reports' 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