Hi,
I would like to get the pass percentage from the overall test cases by project, please suggest how I can achieve.
Hi!
With following formula, you can calculate what part of total tests have passed.
CASE WHEN [Xray Test Execution Status].CurrentMember IS [Xray Test Execution Status].DefaultMember
THEN
([Measures].[Xray Tests executed],
[Xray Test Execution Status].[PASS])
/ [Measures].[Xray Tests executed]
END
Please make sure you change the formatting of the result to %.
The result will display on the total level of Execution status, see screenshot below
Note that some tests might have been failing first, but if they have Passed at some time they will be counted in the Pass and it might give the total 100% as in the screenshot above.
Please let me know if you have further questions regarding this!
Lauma / support@eazybi.com