Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Creating burndown chart to display financial data

chrisreidr
Tera Contributor

‎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?

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?

0 Helpfuls
  • 697 Views
2 REPLIES 2

Uncle Rob
Kilo Patron

‎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.

0 Helpfuls

chrisreidr
Tera Contributor
In response to Uncle Rob

‎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:

 

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. 

0 Helpfuls