Creating burndown chart to display financial data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2023 11:44 AM - edited 06-30-2023 11:50 AM
Although I have seen OOB burndown charts for sprints and stories they do not appear to be what I need. Reports don't seem to have the ability to create what I need either.
Given a table with each record containing a project name, quarterly forecasts, and an actual burn rate, how can I create a chart similar (as close as I could find) to the one below in the Service Portal?
Would I use chart.js, highcharts, or somehow build it from scratch using Server Script to call the data then Client Script and HTML to display it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2023 01:28 PM
This looks like something one could build using the Data Set functionality of a standard report... but I have no idea the criteria for each element being displayed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2023 02:16 PM
Thanks for the suggestion, Robert. The closest I can get to what I need is a Pareto chart but is still not presenting the data I need as seen below:
I'm still relatively new to ServiceNow reports. Would there be a way I can customize this to replace the percentages on the y-axis with currency values, make the line a projected value from the table (to represent the forecasted burn rate), and divide the data into annual quarters?
I have all of the data for each record on the financial table. Just no way to truly present it the way I need to.