Need measure to calculate "planned to date" based on xray test plan begin date and end date

Questions & Answers
1

I need to create a eazyBI report similar to below table :

image
image1220×152 10.9 KB

Please help, Thank you

2

Hi @YathishAradhya,
​
It is possible to create the report in eazyBI, resembling the core functionality of the report displayed in the screenshot.
​
​However, the layout might be a bit different.
​Another point is that a more detailed description of each category is required to provide details on how to build these measures within eazyBI.
​
​Once that calculation logic is defined, we might assist in creating the proper expressions.
​
​Please share more details.
​
​Regards,
​Oskars / support@eazyBI.com

3

Hi @oskars.laganovskis,

Thank you for writing back.
I am glad to provide you more information.

This report aims to provide details of xray test execution tied to xray test plan
we typically create xray test plan and add all test cases to be be executed for a particular regression cycle.

  1. column name “Total TC’s” should provide total test case count of xray test plan
  2. column name “Planned To Date” should provide total test cases should be have been executed as per number of days available by xray test plan (considering begin date and end date of test plan, understanding no of working days and as per given system date, how many test cases it should execute, theoretically (total cases/no of working dates) and it should eventually add up number of test cases to be executed for a give day
  3. Column name “Actual Execution” should provide data of test cases which are executed (irrespective of Pass or Fail status) - all latest execution results
  4. Column name “Total Passed” should provide data of test cases which are passed - all latest execution results
  5. Column name “Total In-Progress” should provide data of test cases which are in status “EXECUTING” - all latest execution results
  6. Column name “Total Failed” should provide data of test cases which are Failed - all latest execution results

I am fine with layout being different; appreciate your help.

Thanks,
Yathish

4

@oskars.laganovskis : any update please, it will be really helpful if you can help me with above request; kind of critical for me to build report for status report for projects & applications