In this exercise, you'll learn how to populate the Issue time tracking from some issues with pivot tables on a Xporter generated file.
This template is going to have two sheets.
Let's create the first sheet. If you want to display the header you must create the Header using a table with 6 columns and 1 row:
Issue Type | Key | Summary | Estimated (Hours) | Remaining (Hours) | Logged (Hours) |
---|
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 add the &{for issues...} statement, so the Header is printed only one time.
On this case is a template on Excel, so don't forget the note below.
Using an XLSX template, please take note that to define an iteration for multiple columns, you need to merge a row of columns and define the &{for issues...} inside that merged cells. The same thing should be made to define the &{end} of the same iteration. All content between the &{for issues...} definition and the &{end} will be duplicated for each iteration. |
With that done, you create another row table where the Issue Comments will be populated:
${IssueTypeName} | ${Key} | ${Summary} | %{Number(“${OriginalEstimate}”/3600)} | %{Number(“${RemainingEstimate}”/3600)} | %{Number(“${TimeSpent}”/3600)} |
Now close the statement using the mapping &{end}.
Finally, we need to give filters to the headers of the table in order for the table to work with the pivot tale. To do this, Select the first cell of the header ("Issue Type"), find the "Sort & Filter" options, and select "Filter".
Well, the first sheet is complete, extracting all the data we need. Let´s go to the second sheet.
We are going to create a pivot table.
A pivot table allows you to extract the significance from a large, detailed dataset. |
Now, The PivotTable fields list appears.
The configuration of a pivot table is done but you are going to add a chart.
To display only once both table and chart, you can filter the issues iteration with:
You'll have to close the code above with &{end} on the cell below the chart. |
Below there is a sample of how the mappings will be displayed in an Excel template:
Below there is a sample of how the generated file will be populated:
If you like this exercise, please share your opinion on the page by just leaving a comment or a . Your opinion is very important to us. Thank you in advance. Enjoy our product. |
Here's the Exercise 2 related files:
|