HI,

Im creating the report to determine backlog status health for all Groups.

Formula i used = CASE WHEN [Measures].[backlog Story Points] > ([Measures].[Average sprint velocity for 3 months] * 3) THEN ‘1000’ WHEN [Measures].[backlog Story Points] > ([Measures].[Average sprint velocity for 3 months] * 1) AND [Measures].[backlog Story Points] < ([Measures].[Average sprint velocity for 3 months] * 3) THEN ‘500’ WHEN [Measures].[backlog Story Points] < ([Measures].[Average sprint velocity for 3 months] * 1) THEN ‘150’ END

Although im getting the expected output for the above formula in Table. But when i click on Bar or Line or Pie chart. Data’s are not getting populated. its just showing empty graph or line or Pie.

Hi,

You could try returning integer numbers (instead of “string”) in your calculation which eazyBI would understand as numbers for the chart.

In your code currently you return string type of values ‘1000’, ‘500’ which can’t be vizualized on a chart.

Try the following code:

`CASE WHEN [Measures].[backlog Story Points] > ([Measures].[Average sprint velocity for 3 months] * 3) THEN 1000 WHEN [Measures].[backlog Story Points] > ([Measures].[Average sprint velocity for 3 months] * 1) AND [Measures].[backlog Story Points] < ([Measures].[Average sprint velocity for 3 months] * 3) THEN 500 WHEN [Measures].[backlog Story Points] < ([Measures].[Average sprint velocity for 3 months] * 1) THEN 150 END`

Note that all branches (“Then”) should return the same data format in order to make this work.

Martins / eazyBI support

Thanks much martins. You are awesome…

1 Like