Josh Bridgens Posted October 25, 2019 Share Posted October 25, 2019 Hi All, Just wondering whether anyone has found the best way to show a "resolver of the week" on a dashboard? (Who has the most calls resolved this week) We are trying to refresh the Dashboards in the office to give off a much more "positive, user oriented" feel than our current heavily stats based data. Josh Link to comment Share on other sites More sharing options...
Bob Dickinson Posted October 25, 2019 Share Posted October 25, 2019 Hi @Josh Bridgens There are various things you can show or use - forgive the colour scheme(!), but I've created 3 widgets here (a Custom list of Data, a counter, and a chart) to show 3 different variables relating to the resolution of calls Let me know if any of these would work for you and I can post the config you might want to use. As an example, here is how the Chart is set up Kind Regards Bob Dickinson Link to comment Share on other sites More sharing options...
Josh Bridgens Posted October 25, 2019 Author Share Posted October 25, 2019 Hi @Bob Dickinson Id love to see how you've done the top 2 widgets! They look excellent, just what I'm looking for. Josh Link to comment Share on other sites More sharing options...
Bob Dickinson Posted December 13, 2019 Share Posted December 13, 2019 Sorry @Josh Bridgens - I've just realised I never got back to you! Also @baker - please see below for the configuration: Widget 1 - The Name of the Top Resolved This Week (from the most recent Sunday) Widget Type - List of Data (Custom) SQL String: SELECT h_resolvedby_username AS Winner FROM h_itsm_requests WHERE h_status IN('status.resolved', 'status.closed') AND h_resolvedby_username != '' AND h_dateresolved >= curdate() - INTERVAL DAYOFWEEK(curdate()) -1 DAY GROUP BY h_resolvedby_username ORDER BY COUNT(*) DESC LIMIT 1 Set up Screenshot: Widget 2 - The Total Number of Resolved Calls This Week (from the most recent Sunday) Widget Type - List of Counters SQL String: h_status IN('status.resolved', 'status.closed') AND h_resolvedby_username != '' AND h_dateresolved >= curdate() - INTERVAL DAYOFWEEK(curdate()) -1 DAY Set up Screenshot: I hope this helps! You may need to add some additional criteria to your WHERE clauses based on your requirements e.g. h_requesttype if you wanted to filter between Incidents, Service Requests, Changes etc. You can use our reporting reference for more help on the additional column names and what they contain: https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table Please let me know if you have any issues. Kind regards Bob 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now