Need formula for Defect Burn Down Rate

[Anonymous]

Please help to get formula for this graph in Qliksense

[etrotter]

Once your data is loaded, select line chart and your months would be your dimensions, and your Sum([Defect Burndown Rate]) would be your expression and it will create that graph.

[Anonymous]

the data of dimension is like a current month but I am not sure How to divide the month in different weeks like Week1 Week 2 Week 3 Week4 and Week 5.

[etrotter · Accepted solution]

Are you using a master calendar?

[Anonymous]

No Erica I am not using Master Calendar...Lets say if CurrentMonth is September so I want to divide the current month in 5 Weeks and use it as Dimension.

[priyalvp24]

Create week using master calendar.

Use that week field as dimension.