Hello,
We have a query that shows the count of tickets and their open and closed times. What we would like to do is show over the last week the total tickets opened per day then show the number of tickets closed per day on the same graph. Is this possible with this search or does something else need changed? I imagine the charting function would be something like this | chart count over dayofweekvariableweset by status
The concern is how would we specify the "dayoftheweekvariable" when we are looking at OPEN_TIME and CLOSE_TIME ?
| dbquery ServiceCenter limit=1000 "select NUMBER AS 'Ticket',
datediff(day,OPEN_TIME,GETDATE()) AS 'Total Days Open',
STATUS AS Status, ASSIGNMENT AS 'Assignment Group',
OPEN_TIME AS 'Open Time',
datename(weekday,OPEN_TIME) AS Day_Open,
OPENED_BY AS 'Opened By',
UPDATE_TIME AS 'Update Time',
CLOSE_TIME AS 'Close Time',
datename(weekday,CLOSE_TIME) AS Day_Closed,
CLOSED_BY AS Analyst,
BRIEF_DESCRIPTION AS 'Title'\nfrom dbo.PROBSUMMARYM1\nwhere ASSIGNMENT = 'TOOLS TEAM' AND (datediff(day,OPEN_TIME,getdate()) <=7 OR datediff(day,CLOSE_TIME,getdate()) <=7)\nORDER BY 'Total Days Open' desc"
| convert ctime("Update Time") ctime("Open Time") ctime("Close Time") |
... View more
