I am creating a chart that needs to show Total Tickets created per month for a year and Total Tickets resolved per month. I have the chart working for Resolved Tickets but not for Total Tickets.
The problem with performing that is that all of my dates are in UNIX time which which is all the seconds sinc January 1, 1970. Unless I am missing something?
My months are off as they do not go June first to June 30 or May 1 to May 31. My Months go from what ever day is today to the corresponding day the previous month and sets that as current month. As far as your question about actual months. How do I determine actual months that will fix my...
I am getting months to figure out based on todays date but My months are off. For example July 10 to June 10 is one month but tomorrow my month will be July 11 to June 11.
first formula
(({HelpDesk.Status} = 5 or{HelpDesk.Status} = 4) and
({@H_ConvertResolvedtoDate} >=...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.