Burn down chart Expression

[Anonymous]

Hi Team,

I have created a line graph with  date in x axis (xdate) and count of test cases executed and planned in that particular date. I want to convert it into burn down chart.The expression i used is sum(if(plandate=xdate,1,0) and sum(if(exedate=xdate,1,0)).How to convert it into burndown chart?

I have tried with total(plandate)-sum(if(plandate=xdate,1,0)).It is not coming. should we use accumulation for this ?

Thanks in Advance.

[#2]

Hi Prakash,

you should use the following formula:

Sum(Total testcases) - RangeSum(Above(Sum(testcases),0,RowNo()))

Greetings,

Marc