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.

Need help

Discussion in 'Kayako reports (Kayako Classic)' started by Webmaster@METRO, Sep 2, 2016.

  1. Webmaster@METRO

    Webmaster@METRO New Member

    I made this report, to cout new tickes last month, and compare whit used time.
    But if I dont have one new of the Tickets.Type last month, it never show time spend last month.
    I need both.
    Thanks !

    SELECT COUNT(*) AS 'Total', sum('Ticket Billing.Time Billable')/3600 as TimeWorked
    FROM 'Tickets' WHERE 'Tickets.Creation Date' = LastMonth() GROUP BY ('Tickets.Type')
     
  2. Gary McGrath

    Gary McGrath Staff Member

    Hi there,

    You can use Mktime to expand your timeline beyond lastmonth.

    e.g.

    'Tickets.Creation Date' > mktime(0,0,0,7,1,2016) AND 'Tickets.Creation date' < mktime (23,59,59,7,30,2016)

    Gary
     
    Webmaster@METRO likes this.
  3. Webmaster@METRO

    Webmaster@METRO New Member

    But I dont think that is the case.

    I have it here:
    SELECT COUNT(*) AS 'Total', sum('Ticket Billing.Time Billable')/3600 as TimeWorked
    FROM 'Tickets' WHERE ('Tickets.Creation Date' > '2016-01-01 00:00:22' AND 'Tickets.Creation Date' < '2016-12-01 00:00:22')
    GROUP BY ('Tickets.Type')



    Jan 2016:
    Create date: 05-jan-2016
    Type: Windows
    Time billig:
    05-jan-2016 1,5 hours
    07 -feb-2016 2,4 hours
    06-mar-2016 4,5 hours

    In feb i make my rapport for last month(JAN2016).
    Type: Windows Time spend: 1,5 hours

    But do i make this rapport MAR-2016, the report do not show any activity, event if I spend 2,4 hours, be cores there is no NEW created ticket in MAR-2016.
     

Share This Page