Is there a way to generate a report on current number of open tickets in WHD? I can generate reports on tickets closed or tickets opened, but how do I identify how many tickets had a status of open at a certain point in time?
Not at a certain point in time because it can only look at the Statuses at runtime of the report. This is where scheduled reports come in where you can get these generated on a regular basis and emailed to you then from this pop into a spreadsheet to see trends. If you have access to something like PowerBI or Excel Power Query to directly connect to the database you may be able to write a query to achieve what you want but out of the box, WHD Reporting cannot do that.
Reports for historical data, Advanced Search (query) for real time. And queries can be used for dashboards, reports cannot.Once you run the query, use the droppy-down thing next to "New Ticket" to export the data in TSV format. What's REALLY cool is that the column set you're using at the time determines the columns in your exported file. For example, I have a column set for "Monthlies." 3 guesses what that one's for.
