Search the Community
Showing results for tags 'month'.
Found 2 results
Morning all i am trying to create a widget that tells me the current months breached Resolution tickets in percentage. So for example. I want something that shows me how many tickets in endpoint have breached this month, in comparison to tickets logged to endpioint for the current month. I am ware i can do this for a measure but would like a widget for the "live" dashboard we use? any idea on the SQL required for this? Thanks Hayley.
Morning all, I am trying to create a widget to tell me the current calls logged this month so far. so from the 1st nov to current date, I don't want to have to change the query every month to keep up and want it to roll each month. So I have written this (I'm quite new to T-sql so it wont be right!): (h_requesttype = 'Service Request' OR h_requesttype = 'Incident') AND DATE(h_datelogged) BETWEEN dateadd(DAY,-(DATEPART(DAY,GETDATE())-1),GETDATE()) AND GETDATE()) however its not working, is this anywhere near right? Could someone point me in the correct direction with this query, also is there a easier way to do it? Thanks Hayley