Zephyr Scale Planned versus Actual

[Howell]

We are using DC version of Zephyr Scale.
Our user wants a graph that tracks the planned vs. actual dates of tests.
The following will be used:

1. Planned end date of test case defined in the Test Cycle.
2. Actual end date of the execution.

The adoption of Zephyr Scale is dependent on the creation of this report. If we can’t create it then Zephyr Scale will be dropped.

Is it possible to generate this kind of report?
Please help! Thanks!

[zane.baranovska]

Hi @Howell,

With eazyBI, you can compare planned vs actual dates for test cycles. eazyBi offers several metrics and properties to describe the testing process. Please see the documentation to see the list of available data and description for each: Zephyr Scale Test Management for Jira.

You might build your report like this:

1. Select properties “Zephyr Scale Test Cycle planned start date” and “Zephyr Scale Test Cycle planned end date” to see the planned dates for individual cycles.

2. Select measures “Zephyr Scale Execution first date” and “Zephyr Scale Execution last date” to see the actual start and end of the cycle based on the execution dates.

   The report might look like in the picture below.
   

   

3. Use conditional cell formatting to compare planned vs actual dates. For example, apply condition cell formatting on the “Zephyr Scale Execution first date” and change the date color based on its value compared to the planned date. For example, you may use formatting like the one shown in the picture below:
   

   

   Custom formula from the example above:

    CASE WHEN
      DateCompare(
        DateWithoutTime([Measures].[Zephyr Scale Execution first date]),
        [Measures].[Zephyr Scale Test Cycle planned start date]) < 0
      THEN "early"
    WHEN 
      DateCompare(
        DateWithoutTime([Measures].[Zephyr Scale Execution first date]),
        [Measures].[Zephyr Scale Test Cycle planned start date]) = 0
    THEN "on time"
    WHEN 
      DateCompare(
        DateWithoutTime([Measures].[Zephyr Scale Execution first date]),
        [Measures].[Zephyr Scale Test Cycle planned start date]) > 0
    THEN "late"
    END
   

   More details on conditional cell formatting are described in the documentation: Conditional cell formatting. Here are details on the DateCompare() function: DateCompare

4. An alternative representation to compare planned vs actual dates is a Bar chart with a Range chart type (see picture below). In that case, place both planned dates side by side and then both actual dates side by side to draw the correct range bars.
   

   
   
   Watch this training video for more details on how to make a range chart: Training videos

[Howell]

Thanks Zane!
Is it possible to report the Test Execution dates?

Inside the Test Cycle, each Test Case has its own Planned and Actual dates. These are the information that our user wants to report.

Regards,
Howell

[zane.baranovska]

Thanks, @Howell, for the screenshot to clarify.

“Actual Start Date” and “Actual End Date” are automatically captured by the Zephyr Scale app based on the testing activities. Those two fields are available in eazyBI as measures “Zephyr Scale Execution first date” and “Zephyr Scale Execution last date”.

The planned dates for individual Test executions are not imported in eazyBI.
I added such improvement to the eazyBI backlog, but I can not estimate when it might be available.

Best,
Zane / support@eazyBI.com