Pie Chart of Associated Test Cases based on Test Plans created date (month)

I’d like to create a pie chart that represents all test cases, based on execution status, associated to Test Plans created in a specific month. The driving force behind the report is the month the Test Plan was created in. When the test case or test execution was created is irrelevant for this report. Would like to simply see the connection of all test cases for all test Plans created within a specific month.
The closest I’ve gotten is this:

After further research I don’t think TestRunStatus is the measure I want to use (the data is not matching). And this pie chart is providing data based on test case created dates.

I’ve also tried creating a new calculated measure using CASE statement to include the created date for TestRunStatus to be the beginning statement but I get an error “failed to execute query” with no error message (sorry tried to post the code but not allowed as a ‘newbie’ poster)

Any help without judgment is greatly appreciated. Seems so simple but I’ve been at this for days now.

Here is the code I was referring to in the original question:


Try using DateInPeriod in the Cas when validation part.

[TestRunStatus].CurrentMember.level.name = "TestRunStatus"
[Xray Test Plan].currentmember.get('Created date'),

If that didn’t help please reach out to support@eazybi.com and provide your report definition.

Martins / eazyBI