Jump to content

Chart Widget grouped by Priority and team


Joyce
 Share

Recommended Posts

I am trying to create a chart  widget for active Incidents grouped by priority, and Team. Basically I am looking for something like this: (please see attached Print screens).

Currently I can get widget either by priority or by team. How can I combine them in one widget? I am interested on the count (so how many active P1 assigned to a team).

 Thanks.

Regards,

HornBill SM_Chart Widget grouped by Priority and team.docx

Link to comment
Share on other sites

  • 3 weeks later...

Hi @Joyce

This report is possible to build in Hornbills Advanced Analytics, as a "SQL Group By" chart widget.

You will need to know the names of all of the support teams that could be assigned calls - as each of these will be set up as a separate series. For example in my screenshots below, I have set up the 3 support teams each as their own series ("1st Line Support", "2nd Line" and "Facilities") - in my screenshot, I have showed you the SQL that was needed for the 1st Line Support series, but its exactly the same for the other 2 - just replace the team name. 

The end chart looks like this:

A1.png

 

And some screenshots of how it was configured follow:

A2.png

 

A4.png

A3.png

A5.png

 

I hope this helps you create the widget you need! Let me know if you have any issues or questions.

Kind Regards

Bob

Link to comment
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
 Share

×
×
  • Create New...