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.
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_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.
The table brought back is as follows:
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:
Example:
We have 3 columns returned for our users Conner and IT Monkey.
- WorkItemId
- TicketType
- 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
Comments
I wonder if that'll have the ability to Stack....