I request your support as I am not able to perform the queries on my own. I have defined a custom field which is based on issue links:
This link type is used to track the coverage between two issue types (Requirements & Tests). A requirement is considered as covered if there is at least one Test linked to it.
I am able to calculate the global coverage with the last refreshed data set but I would like to plot the coverage evolution during time. To achieve this goal I have defined the following settings:
- Pages: Project, Issue Type, Status
- Rows: Time, Weekly
- Measures: [Measures].[Issues history]
Now, I would like to add a new measure based on a weekly timeline to known how many issues are covered using the above custom field. I tried to add the two following parameters to the custom field but I am getting errors so it looks that it’s not working:
- separate_table = true
- changes = true
I searched the forum and found this link that might help: Issue linking - History - Questions & Answers - eazyBI Community
But I am blocked to go further. Any help would be appreciated.
I didn’t understand… can’t you see the content to which the link points?
I have no idea why you are blocked
Copy it for you?
Here is the result for a live data calculation:
This calculation is done using the following rules:
- Requirement Jira issue type is used to detail product specification
- Test Jira issue type is used to detail a product test
- Coverage (%) is the division between all the Requirements in the product and all the Requirements ns the product covered by at least one Test (“tested by” relationship).
Now, I would like to see the coverage evolution on a weekly basis to highly the coverage trends. This is achieved with historical measures but I don’t known how to calculate the coverage value for each weekly steps. Meaning that for every week, I need to know the number of Requirements in the product and the number of Requirements covered by a test (“tested by” relationship) to perform the calculation.
To illustrate, below is a time representation of the Requirement statuses on a weekly basis. I would like to do the same for the coverage value to plot the trends.
eazyBI does not receive information on when the line between Test and Requirement is created. You may get a list of currently available links (the report you already have).
Those two parameters,
separate_table = true and
changes = true, are not supported for issue link dimensions. Those could be used only on single-select issue custom fields (Advanced settings for custom fields).
Zane / support@eazyBI.com