Displaying results as previous day's result in easyBI

Questions & Answers
, , ,
1

Hi,

So I created a Burndown Chart that consists of Ideal Burndown rate and Actual Burndown rate as shown:

image
image489×681 6.74 KB

So what I wanted to know is that, is there a way to display the result of the actual burndown rate as previous day’s result, if no test executions has been made instead of the total executions? which in this case is 31.
So for example: On may 18th it displayed the total executions which is 31 (Which means no tests were executed) but instead I want it to report what happened on may 15th which is 20 executions, but for may 18th:

image

Thanks in advance!

2

Hi @Rubina
there is an option to return the value of a previous member when “Time” dimension is used.

CASE WHEN
[Measures].[Test executions]>0
THEN
[Measures].[Actual burndown rate]
ELSE
Sum(
(
[Measures].[Actual burndown rate],
[Time].currenthierarchyMember.PrevMember
)
)
END

If that didn’t help, please share the report definition

Martins / eazyBI

3

Hi @martins.vanags
I got an error when using the code:

image
image897×498 26.3 KB

4

Try using sum in both branches

CASE WHEN
[Measures].[Test executions]>0
THEN
Sum(
	[Measures].[Actual burndown rate]
)
ELSE
Sum(
(
[Measures].[Actual burndown rate],
[Time].currenthierarchyMember.PrevMember
)
)
END

Martins / eazyBI

5

Hi @martins.vanags,

I tried that as well and the code didn’t work. Is there a different approach to get the previous result if no test executions were made?

Thanks

6

Hi,

Please export and share the definition of your report.
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions

Martins / eazyBI

7

@martins.vanags is it possible to get an email to export and share the definition?

8

@Rubina

Please use support@eazybi.com to send more details about your use-case.

Martins / eazyBI support

9

@Rubina could you please post the response here when you get it? Following this thread as well!

Thanks!

10

@Bryan_Rosenthal most certainly!

Thanks to @martins.vanags

The solution for the Actual Burn-down code is to first add the Actual Burn-down of ATM Test Cases Executed_ActualTest1:

CASE WHEN
[Measures].[Actual Burn-up of ATM Test Cases Executed]>0
THEN
 ([Measures].[Actual Burn-up of ATM Test Cases Executed]) 
ELSE
(
  Cache(
    DefaultContext((
      [Measures].[Actual Burn-up of ATM Test Cases Executed],
      [Project].CurrentMember,
      [TM4J Test Plan].CurrentMember,
      Tail(Filter(
        [Time].[Day].Members.Item(0):
        Tail(Descendants([Time].CurrentMember, [Time].[Day])).item(0),
        CACHE (Not IsEmpty(Defaultcontext((
          [Measures].[Actual Burn-up of ATM Test Cases Executed],
          [Time].CurrentMember,
              [Project].CurrentMember,
                [TM4J Test Plan].CurrentMember          
        ))))
      )).item(0)
    ))
  )
)
END

And then to have another calculated member defined such as ActualBurndown which will be used in the report columns:

CASE WHEN
[Measures].[Actual Burn-down of ATM Test Cases Executed_ActualTest1]>0
THEN
Nonzero([Measures].[Actual Burn-down of ATM Test Cases Executed_ActualTest1])
ELSE
0
END

Thanks!

1 Like