Forum Discussion
Solved
Issue Tracker Number Field
I am using Issue Tracker in Sharepoint for Incident Tracking, I would like to use the Graph App to display Ticket Status; How many Complete, In progress, etc. Unfortunately my issue tracker does not ...
- I'm not sure if it's possible with just using the out-of-the-box features. As you mentioned the totals will only apply to records that are within the list (not filtered out).
My suggestion would be to look at connecting to your list via Power BI and creating a chart there that you could then put into your page via the Power BI Webpart. You could then build other stats and provide the info in a Power BI dashboard. You should be able to fairly easily get a count of ALL records, then perform a calculation for the percentages of active tasks across all tasks.
Another option is to create a separate list that just contained info for the active tasks (to be used in your chart) and populate it using a scheduled Power Automate from info contained in your incidents list.
Kelvin_D Not sure which "Graph App" you are referring and what you are trying to do exactly.
But, all SharePoint has ID as a default number column in all lists. Maybe you can utilize this number column for your application.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.