Burn down chart

[karin_nevo]

Hi,

I am creating a burn down chart using the following expression:

sum(total Hours)-RangeSum(Above(TOTAL Sum(Hours), 0, RowNo(TOTAL))).

and Quarter as dimension

I am getting the required result, but I want the chart to display also the sum of hours (sum Total Hours) for all periods.

For example, in TableCapture.PNG, the total appears in the expression column (1382).

I want the same total to appear as starting point in ChartCapture.PNG . Is it possible?

I tried to use "Show Total" in dimension limit but it didn't work

Thanks,

Karin

[sunny_talwar]

Are you looking for an additional point on the x axis which displays the total and then the burn down? May be try this

Dim:
LOAD * INLINE [
Dim
1
2
];

and then use this as your dimension

Pick(Dim, 'Total', Quarter)

and this expression

Pick(Dim,
  Sum(Hours),
  Sum(TOTAL Hours) - RangeSum(Above(TOTAL Sum(Hours), 0, RowNo(TOTAL))
)

[karin_nevo]

Thank you for your help.

I tried what you suggested, but I get: "No data to display" message on the chart.

any idea why?

thanks!

[sunny_talwar]

Would you be able to share a sample to test this out?

[karin_nevo]

I was able to get a result now on a sample data, but it is not the correct result.

On the first chart, you can see the correct data for all quarters (without total)

On the second chart, the total is correct, but the data for the quarters is incorrect.

thanks,

Karin

[sunny_talwar · Accepted solution]

Try this

Pick(Dim,
Sum(Hours),
Sum(TOTAL Hours) - RangeSum(Above(Sum(If(Dim = 2, Hours)), 0, RowNo()))
)

[karin_nevo]

It works!

thank you very much for your help 🙂