Hi All, I believe, I have a basic question: Trying to count tickets per client per month, expected result:
January 3 Customer 1 January 15 Customer 2 January 1 Customer 3 February 15 Customer 1 February 10 Customer 2 February 2 Customer 3
But instead i just getting :
January 1 Customer 1 January 1 Customer 2 January 1 Customer 3 February 1 Customer 1 February 1 Customer 2 February 1 Customer 3
This is my query:
SELECT DATENAME(MONTH,datetimeOpened)AS PerMonth, COUNT(fldIWfId) AS Tickets, OrganizationfldName AS Customer FROM mytable WHERE datetimeOpened > dateadd(year, -1, GETDATE()) GROUP by OrganizationfldName, fldIWfId, datetimeOpened Order BY PerMonth desc
SELECT DATENAME(MONTH,datetimeOpened)AS PerMonth,
COUNT(fldIWfId) AS Tickets,
OrganizationfldName AS Customer
FROM mytable
WHERE datetimeOpened > dateadd(year, -1, GETDATE())
GROUP by DATENAME(MONTH,datetimeOpened), OrganizationfldName,
Order BY PerMonth desc
Counting tickets per customer per month (basic)
Posted - 02/22/2013 : 04:11:06
