Hello, can I use EazyBI to take multiple subtask End Dates for SDLC phases like
Requirements
Development
FUT
UAT
Prod
and display those End dates in Columns horizontally?
Could you send me links of where to start looking how to do this? So far searches did not find.
Seems like we should be able to do this.
Thanks!
Where and how do you enter the SDLC phases for sub-tasks in Jira?
is that some Select list (single-choice) field that is used in Jira issue screen at the sub-task level?
Martins / eazyBI
Hello, thanks for your response! Appreciate!
To explain further…
We have a User Story and under that are 8 Sub-Tasks.
The Sub-Tasks have End Dates (Management wants to see the Expected End Dates for each of these Sub-Tasks or phases. There are about 35 Little Projects/Epics with these User Stories and Sub-Tasks that are presented weekly.
I am trying to recreate the powerpoint slides using Jira and EazyBI or ScriptRunner
For example, the SubTasks are typical project phases
Requirements Provided
Requirements Aligned
Final FS
FS Approved
Dev+FUT Complete
UAT
Prod
We can display the End Dates in the Advanced Roadmap Plans in an outline format, which is great. This works using Subtasks with End Dates.
However… If management wants to see these Subtasks and End Dates for 34 of these projects, if we display them in a typical outline format, Vertically, then that will be too many pages in the presentation. One or two Epic/project/user Stories would take an entire page/slide in the deck.
So, the question is, how can I display these Sub-Task End Dates Horizontally?
For Example, the Sub-Tasks and the End Dates would be columns (displayed horizontally)
Epic 1 Req Provided Req Aligned Final FS FS Approval Etc…
End Date End Date End Date End Date
Epic 2 9/25/24 9/30/24 10/12/24 10/20/24 Etc…
Epic 3 10/1/24 10/5/24
The short answer is they are the End Dates of the Subtasks.
@Rachel_Rutti
Please let me understand it better
Does each sub-task have multiple end dates? or just 1 end date per sub-task?
If it is one, is the name the same for the Jira field for each sub-task or names are different (but 1 field per 1 sub-task)?
Let’s use your example with Epic 2
Does it mean it will have Sub-task 1 with Req Provided End date = Sep 25 2024, Sub-task 2 with Req Aligned End date 30 Sep 2024 etc?
And do you link sub-tasks directly to epics (skipping story level)?
Martins / eazyBI
I’ll answer in-line.
Thank you again!
Does each sub-task have multiple end dates? or just 1 end date per sub-task?
*Each subtask has one End date, however, we would like to keep track of the history when dates change and if possible display those somehow. That may be a big ask, so the initial ask is to display the End Date for the 8 subtasks horizontally.
*
If it is one, is the name the same for the Jira field for each sub-task or names are different (but 1 field per 1 sub-task)?
It is one End Date for each sub task
The name of the End Date field on the Subtask is the same for each subtask.
The actual Summary/Title/Name of the Subtasks will be the same also across Epics/stories.
(Each story or Epic should have the same 8 subtasks with the same names/titles/summary - for Example, each story would have a Requirements Provided subtask and all the subtasks have the End Date field.)
Let’s use your example with Epic 2
Does it mean it will have Sub-task 1 with Req Provided End date = Sep 25 2024, Sub-task 2 with Req Aligned End date 30 Sep 2024 etc?
*Yes, each Epic (or Story) would have the same 8 Subtasks
Requirements Provided
Requirements Aligned
And do you link sub-tasks directly to epics (skipping story level)?
I’m sorry that was my mistake. I did say Epic and forgot to go back and correct that.
*Currently, we do have User Stories and Subtasks under Stories.
we do not put SubTasks directly under an Epic…
Sorry about that…
To be honest, I am having a hard time just seeing my data come into EazyBI.
I see it imports based on my query.
But I do not see the data on any of the tabs.
I tried doing a small query that should bring in two epics.
Martins / eazyBI
[/quote]
Please let me understand it better
Does each sub-task have multiple end dates? or just 1 end date per sub-task?
If it is one, is the name the same for the Jira field for each sub-task or names are different (but 1 field per 1 sub-task)?
Let’s use your example with Epic 2
Does it mean it will have Sub-task 1 with Req Provided End date = Sep 25 2024, Sub-task 2 with Req Aligned End date 30 Sep 2024 etc?
And do you link sub-tasks directly to epics (skipping story level)?
Martins / eazyBI
Hi,
The remaining questions:
Is it always just 8 sub-tasks for each epic (not more, not less)? And how they are distributed per user(stories) under epic?
Is there some naming pattern for sub-tasks - if the same name of the Jira custom date picker field is used at a sub-task level to enter the “End date” how can eazyBI know which of 8 sub-tasks should be used for each column in the report? (is it summary or description)?
Do you want your report to show epics in rows (without going deeper to the user-story level) and then 8 columns for each epic? If so, is there any particular sequence of the subtask’s end dates you want to have in the report?
Martins / eazyBI
Basically, I want to reduce the need to manually make a slide like this and have the Jira data produce this information.
Please reach out to support@eazybi.com with more details about the sub-tasks.
Except for the last column with comments, I believe it would be possible to create the report
Martins / eazyBI
Okay, great, thanks so much! Will do!
Oh no, you mean it won’t support the Most Recent Comment? That is the latest status. We need that. That would really be disappointing because the Advanced Roadmap or Plans in Jira don’t seem to support it either.
@Rachel_Rutti
Please find the example on how to define new calculated field to import “last comment” for each issue:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/javascript-calculated-custom-fields/calculated-field-examples/last-comment
Martins /eazyBI