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.

Graph - Creation Date Week vs Closure Date Week

Discussion in 'Kayako reports (Kayako Classic)' started by KarlH, May 8, 2020.

  1. KarlH

    KarlH Member

    This is a report I use for Tickets Created over the past 3 months

    Code:
    SELECT COUNT(*) AS 'TOTALCREATED' FROM 'Tickets'
    
    Where 'Tickets.Creation Date' > DATE_SUB(ThisWeek(),INTERVAL 12 Week)
    
    Order By 'Tickets.Creation Date'desc
    GROUP BY X('Tickets.Creation Date':Year),X('Tickets.Creation Date':Week), Y('TOTALCREATED')
    
    And an almost identical report for Tickets Closed over the past 3 months;

    Code:
    SELECT COUNT(*) AS 'TOTALRESOLVED' FROM 'Tickets'
    
    Where 'Tickets.Resolved Date' > DATE_SUB(ThisWeek(),INTERVAL 12 Week)
    
    Order By 'Tickets.Resolved Date'desc
    GROUP BY X('Tickets.Resolved Date':Year),X('Tickets.Resolved Date':Week), Y('TOTALRESOLVED')
    
    However, I can't for the life of me configure both reports into one, so that I have a simple line graph that shows the created tickets with one colour and the closed tickets with another. Any advice?
     

Share This Page