Hello ,
I have the following hierarchy in Jira:
-Epic
-“Technology” issuetype , linked to the epic with linktype “is tech of”
-“Employee” issuetype, which is a sub-task , under the “Technology” issuetype, having a customfield called “Grade”.
I want to create a table for this use case to be able to display all the hierarchy in it, and to be able also to filter by “Grade” dimension.
Appreciate any help.
Cheers!
Hi @Michmbayed1,
You might build the relevant hierarchy within the Issue dimension. Please read more about that here -Additional Issue hierarchies.
The code to be added to eazyBI advanced settings might be as follows.
[jira.customfield_technology]
name = "Technology"
inward_link = "jira_subtask_inward"
issue_type = "Technology"
update_from_issue_key = "subtask_key"
dimension = true
[jira.customfield_epicfortech]
name = "Technology Epic"
outward_link = "is tech of"
issue_type = "Epic"
update_from_issue_key = "customfield_technology"
dimension = true
[[jira.issue_hierarchies]]
name = "Employees by tech"
all_member_name = "All Employees by tech"
levels = [
{name="Epic",key_column="customfield_epicfortech",issue_type="Epic"},
{name="Technology",key_column="customfield_technology", issue_type="Technology"},
{name="Employee",key_column="subtask_key", issue_type="Employee"}
]
The actual syntax might differ slightly depending on your Jira and eazyBI versions.
After adding this code, you would need to select the fields “Technology” and “Technology Epic” for import.
This should create a new hierarchy within your Issue dimension.
As the field “Grade” is available at the Employee level - the measure filtering will work accordingly.
Regards,
Oskars / support@eazyBI.com