HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Report by Customer


#1

We track customer_id by the name of the company. What we would like to have is a report that would show basically who are the top companies that opened up tickets for a certain period of time. Is that possible to do today.


#2

There’s the request by unique customer report, but it doesn’t group them my customer in terms of most to least. I don’t think this report can be pulled out currently, though it should be pretty easy to do in SQL. I think something like this would work:

SELECT sUserId, count(*) as thecount
FROM HS_Request
WHERE dtGMTOpened > 1171460581
GROUP BY sUserId
ORDER BY sUserId

This will provide counts by customer ID in order of most requests for the last month. The number after > is the Unix timestamp. You can change that for another timestamp to create your reports or also add a AND dtGMTOpened < XXXX where xxxx is another timestamp if you want to create the reports for a certain period of time. So between January 1st and 31st.

You can find the timestamps for a date using this site:
http://www.4webhelp.net/us/timestamp.php