How to draw a burndown line in an arsenal graph/report

This article explains how we can draw a burndown line in an arsenale graph/report with scripts.

\uD83D\uDCD8 Instructions

1. Please access your report by navigating to Dataplane Reports → Reports → My Reports

2. Open the report where you want to draw a burndown line in an arsenal graph/report and 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"
   }

3. Click on Run Report to get the burndown line in your report.