This article explains how we can draw a burndown line in an arsenale graph/report with scripts.
\uD83D\uDCD8 Instructions
Please access your report by navigating to Dataplane Reports → Reports → My Reports
Open the report where you want to draw a burndown line in an arsenal graph/report.
Use the below Script in the Customizer Script field.
YEAR_COLUMN_NAME = "Year" MONTH_COLUMN_NAME = "Month" DAY_COLUMN_NAME = "Day" VALUE_COLUMN_NAME = "Time Spent (Hours, Historical)" def startDate def startValue def endDate def endValue def formatDate(int year, int month, int day) { return String.format("%04d-%02d-%02d", year, month, day); } customizeResult { def m = getMatrix() def yearCol = getColumn(YEAR_COLUMN_NAME) def monthCol = getColumn(MONTH_COLUMN_NAME) def dayCol = getColumn(DAY_COLUMN_NAME) def valueCol = getColumn(VALUE_COLUMN_NAME) def startDateRow = 0 def endDateRow = m.rowCount()-1; startDate = formatDate(m.getValue(startDateRow, yearCol), m.getValue(startDateRow, monthCol), m.getValue(startDateRow, dayCol)) startValue = m.getValue(startDateRow, valueCol) endDate = formatDate(m.getValue(endDateRow, yearCol), m.getValue(endDateRow, monthCol), m.getValue(endDateRow, dayCol)) endValue = 0 } customizeChart { lineAnnotation "Ideal Burn Down" from (startDate, startValue) to (endDate, endValue) color "red" style "dotted" }
Click on Run Report to get the burndown line in your report.
You can modify script based on your requirement to draw burndown line.