I want to see cancelled ticket count only for last 14 days . how can I create a report for it ?please help

jay97
Tera Contributor

find_real_file.pngI want to see cancelled ticket count only for last 14 days . how can I create a report for it ?please help

 

please share the report query.

6 REPLIES 6

Mohith Devatte
Tera Sage
Tera Sage

Hello,

are you storing the date when it was cancelled ?

no it is a status only . I have attached the photo

no it is a only status value of incident

I would add to your logic the 'updated' for the 14 days or you could use the closed