1

Top Brass at my company loves the metrics that our On-Premise Helpdesk Dashboard puts out, but they want to see past 90 days, 180 days, year… with those exact same graphic metrics that they’re all used to seeing.

Does anyone know where in the source you can code in those additional drop downs?

I can’t imagine it being too hard if you’re just changing the variable for the lookup to go from 7 to 30 to 90 to 180…ect

For example…this is what it is now…

1.jpg

This is what I would like to do…

2.jpg

9 Spice ups
2

I’ll get torched for this but if you are relying on the Spiceworks metrics to wow the brass, don’t - the dashboard fatal flaw is the display of metric data. There are anomalies that will frustrate you to no end. Especially the reports that inexplicably leave off a tech who belongs in the “top” list. Like I said, I’ll get roasted but alas, you have been warned.

3

Try this:

SELECT users.first_name || " " || users.last_name AS "Assigned to"
 , (SELECT Count(assigned_to) FROM tickets WHERE users.id=tickets.assigned_to and (tickets.closed_at>=date('now','-90 day'))) as "Past 90 days."
FROM tickets 
LEFT OUTER JOIN users ON users.id=tickets.assigned_to
WHERE tickets.assigned_to NOT NULL
GROUP BY "Assigned to"
ORDER BY "Assigned to"

Which I copied and modified from:

Or this if you want a simpler chart (you’ll need to edit the table)

It will do a better job of wow-ing.