Why ticket count is not an integer?

Discussion in 'Kayako Reports' started by Cuong Le, May 18, 2012.

  1. 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?
    Cuong Le, May 18, 2012
    #1

  2. masterctrl1 Reputed Member

    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.
    masterctrl1, May 19, 2012
    #2

  3. Drew Keller Just one person in a world of millions.

    Just upgraded to get 4.40.1148 and saw this and yes very annoying.
    Drew Keller, May 20, 2012
    #3
    • Kayako Staff

    Andriy Lesyuk Developer

    Andriy Lesyuk, May 23, 2012
    #4

Share This Page