Creating burndown chart to display financial data

chrisreidr
Tera Contributor

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?

chrisreidr_0-1688150652550.png

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?

2 REPLIES 2

Uncle Rob
Kilo Patron

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.

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:

 

chrisreidr_0-1688159459503.png

 

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.