Jump to content
Lauren

Request Type per Analyst Widget

Recommended Posts

Hi

I am trying to create a widget that displays a bar chart showing the number of open requests per analyst in a certain team, where the x-axis is the analyst (owner) and the y-axis is the number of requests.

Is this possible? If so, how would I go about setting this up? I've managed to create a bar chart that displays the number of requests as a whole that each analyst in a certain team owns, but cannot work out how to split further into request type per analyst.

Thanks

Lauren

Share this post


Link to post
Share on other sites

Hi Lauren

If I have understood your requirement correctly, I believe you are able to do this by adding 2 "Series" to the widget. A series can be found at the bottom of the "SQL Group By" wiget (which I assume you are already using). So if you keep the same criteria you are currently using to get to total number of open tickets grouped by Owner, and add two series - one for Incidents (h_requesttype = 'Incident') and one for Service Requests (h_requesttype = 'Service Request'), this should split each individuals bar chart columns into 2, with the divide between the types

So to set up the series:

Screenshot_2.png


And the resulting chart looks like this:

Screenshot_3.png


Is this what you are looking for?

Share this post


Link to post
Share on other sites

Hi @Bob Dickinson

Thank you for your reply, however I've already sorted this with Dan's help.

Lauren

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...