dwalby Posted October 19, 2018 Share Posted October 19, 2018 Hi all, NOTE: I posted this in Performance Analytics previously, but I'm not sure that's the right place? I'd like to create a widget which shows the number of requests open, logged (created by) and resolved per analyst in a bar graph, similar to the below. Is this possible? I've tried a Measure Group By with multiple series, but it doesn't seem to allow different group by filters to be applied, i.e. Created By for Logged requests & Owner name for Open requests. Any help appreciated Link to comment Share on other sites More sharing options...
Victor Posted November 1, 2018 Share Posted November 1, 2018 @dwalby - I think this can be done by having 3 weekly measure for requests raised (logged), open and resolved. If you only need the last 3 weeks then have the measures sample history set to 3. Then create a data chart widget, which uses this measure. Set the data type in data source to use "Measured Samples". Add all 3 measures as a series in the widget. I have tried this and came up with this: Looks pretty close with the graphs you want... On 10/19/2018 at 1:11 PM, dwalby said: I posted this in Performance Analytics previously, but I'm not sure that's the right place? Performance analytics is intended to discuss the analytics engine or functionality itself. If the discussion is about a measure and widgets using Service Manager data for example then the Service Manager section is the right place ... not sure if this makes sense, is 5 AM now and still having coffee Link to comment Share on other sites More sharing options...
dwalby Posted December 5, 2018 Author Share Posted December 5, 2018 @Victor - Thanks, sorry for the late response on this. I think the graph you've shown displays the metrics I'm looking for, but presumably your measures are for overall performance. I'm looking to create a graph which shows logged, resolved & open for each analyst over the current week/month. I'm guessing I'd need to setup a measure for each analyst to achieve this? I've used some insane paint skillz to hopefully demonstrate what I'm looking for a bit better. Link to comment Share on other sites More sharing options...
Victor Posted December 5, 2018 Share Posted December 5, 2018 48 minutes ago, dwalby said: I'm guessing I'd need to setup a measure for each analyst to achieve this? I am not sure, I need to look into it... I'll get back to you on this. 48 minutes ago, dwalby said: I've used some insane paint skillz to hopefully demonstrate what I'm looking for a bit better 1 Link to comment Share on other sites More sharing options...
dwalby Posted December 19, 2018 Author Share Posted December 19, 2018 @Victor any chance you can look into this? If not in the short term I'll create measures for each analyst individually if needs be. Thanks in advance 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