...
Let's go to create the first sheet whose name can be "Issues", If you want to display the header you must create the Header using a table with 7 columns and 1 row:
Key | Issue Type | Priority | Summary | Status | Date | Month |
---|
Since all the table contents below the Header are dynamic, firstly we need to create a single row Table to be the Header, and below it, add the #{for i=JQLIssuesCount|clause=project = ACD order by Key desc} statement, so the Header is printed only one time.
...
With that done, create another row table where the Issue Comments will be populated:
${JQLIssues[i].Key} | ${JQLIssues[i].IssueTypeName} | ${JQLIssues[i].Priority} | ${JQLIssues[i].Summary} | ${JQLIssues[i].Status} | ${JQLIssues[i].Created} | ${JQLIssues[i].Created} |
Finally close the statement using the mapping #{end}.
...
- Select all pivot table.
- On the Insert tab, click charts. You can pick up all chart. On In this case, I am going to choose the 2-D Column.
- The chart appears on the sheet.
...
We are going to use the Macros to set up the Month field.
...
A new window appears to insert the VBA code. In the created module, insert the following code:
Sub MonthFormat() FinalRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 3 To FinalRow cleanDate = Left(Worksheets("Issues").Cells(i, "G").Value, 10) Worksheets("Issues").Cells(i, "G").Value = "'" + Format(cleanDate, "MMMM-yyyy") Next i Set pvtTable = Worksheets("Chart by Month").Range("A4").PivotTable pvtTable.RefreshTable End Sub |
Note |
---|
When you have a template that only contains a JQL query or a JQL iteration, as in this case, you can export it straight from the menu Xporter Reports. |
...
Info |
---|
If you like this exercise, please share your opinion on the page by just leaving a comment or a . Your opinion is very important for to us. Thank you in advance. Enjoy our product. |
Expand | ||||||
---|---|---|---|---|---|---|
| ||||||
Here's the Exercise 7 related files:
|