Creating more complex charts in the Cireson Portal
Here is an example of how that can be done in the Cireson Portal.
First, you need to define a data source. This query will give the number of open incidents, service requests and change requests which have not been resolved, completed or closed on each day.
;WITH lastTenDays AS
Open the Portal as an administrator, and click on the Admin Settings link on the drop-down menu in the top right-hand corner. Click on the link for Dashboard Query Settings.
Enter 'Work Item Backlog' for the name
Set the Data Source as ServiceManagement
Copy/paste the SQL query from above.
Save the query.
Now open SQL Server and run this query against the ServiceManagement database.
select Id, Title
Copy the guid from the Id field returned by this query.
Now open the file explorer on the Portal server.
Browse to C:\inetpub\CiresonPortal\CustomSpace\views
Create a file called backlog.js in this folder.
Add this code to the file:
Next, open the subfolder called viewpanels in the views folder.
Create a file called vp-backlog.js in this folder.
Add this code to that file:
Finally go back to the Portal and open the Navigation Settings menu from the drop-down menu in the top right-hand corner.
Add a new link to /view/backlog
Set the Title, behaviour, icon and visibility.
When you click on the link you should see:
You can specify a different chart type in the view panel. For example, this is the same data displayed as a stacking area chart.