Home Service Manager Portal Feature Requests
We appreciate you taking the time to vote and add your suggestions to make our products awesome! Your request will be submitted to the community for review and inclusion into the backlog.

We recommend reviewing what is submitted before posting, in case your idea has already been submitted by another community member. If it has been submitted, vote for that existing feature request (by clicking the up arrow) to increase its opportunity of being added to Cireson solutions.

For more information around feature requests in the Cireson Community click here.

Cluster By / Stack By - SQL Chart Widget

Conner_WoodConner_Wood Customer Ninja IT Monkey ✭✭✭✭
I believe a chart with multiple columns next to each other (clustered) is a reasonable request..... potentially you could create another StackBy Combobox to put them on top of each other (but I prefer side by side).  Maybe even both!

Example:
We have 3 columns returned for our users Conner and IT Monkey.
  1. WorkItemId
  2. TicketType
  3. AssignedTo

The table brought back is as follows:

WorkItemId

TicketType

AssignedTo

IR100

Incident

Conner

IR200

Incident

Conner

IR300

Incident

Conner

IR400

Incident

Conner

IR500

Incident

IT Monkey

IR600

Incident

Conner

IR700

Incident

IT Monkey

IR800

Incident

IT Monkey

IR900

Incident

IT Monkey

IR1000

Incident

IT Monkey

SR1100

ServiceRequest

Conner

SR1200

ServiceRequest

IT Monkey

SR1300

ServiceRequest

IT Monkey

SR1400

ServiceRequest

IT Monkey

SR1500

ServiceRequest

Conner

SR1600

ServiceRequest

Conner

SR1700

ServiceRequest

Conner

SR1800

ServiceRequest

Conner

SR1900

ServiceRequest

Conner

SR2000

ServiceRequest

IT Monkey

SR2100

ServiceRequest

Conner

SR2200

ServiceRequest

Conner

SR2300

ServiceRequest

IT Monkey

SR2400

ServiceRequest

Conner

SR2500

ServiceRequest

Conner



As long as rows are returned you can group by "AssignedTo" to create the following chart:


With the Cluster By Combobox it would be possible to select the TicketType column to then show amount of each ticket type:


With the Stack By Combobox it would be possible to show the height of the grand total as if we were using the normal chart but it would show the amount of each:


10 votes

Submitted · Last Updated

Comments

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Basically a second group by option. Agreed
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    Yup, that would be awesome.
  • Conner_WoodConner_Wood Customer Ninja IT Monkey ✭✭✭✭
    I heard the Cireson Analytics are on the way:  "revamped and enhanced version of the Dashboards app. It lets your IT team access valuable data and key performance metrics at a glance with powerful reports and custom dashboards"

    I wonder if that'll have the ability to Stack....
Sign In or Register to comment.