Export further data like assignee name, project name, issue type and implement new pivot tables that match your needs.Ĭreated-pivot-table-template.xlsx - a sample Excel template to generate pivot tables.This will filter your data to show only the outstanding work! Expand and collapse the "Month" and "Day" rows, or completely drop the "Day" field to change the report's resolution.Ĭlick the "Status" field in the Pivot Table Field List bar and uncheck everything, but the "Open" and "In progress" items.Experiment with the tons of interactive features in Excel, for instance:Ĭlick the pivot cells (the ones with the numbers) and Excel will create you a new worksheet listing the issues corresponding to that filtering criteria.įor example, if you the click the intersection of the "Open" column and the "2014 Jan" row, Excel will list you the open issues created in that month. Then, as soon as you open the spreadsheet in Excel, it will find the named data range and display your pivot table. Run a JQL query that returns a list of issues.ĭuring the export, the app will fill the source data cells with actual data.Enable it for at least the "Issue Navigator" context (or "Multiple Issues" in pre-2.2.0 versions). Create a new view named "Status by Creation Date (Excel)" for this new template.This will ensure that no mysterious, deleted experssions appear in the pivot table's filter drop-downs.
Still in the Data tab, set the Number of items to retain per field setting to None. This way Excel will auto-refresh your pivot table after the template is merged with actual data. Go to the Pivot Table ribbon → Pivot Table Options → Data tab:Ĭheck the Refresh data when opening the file checkbox.
#Pivot tables in excel how to#
How to create Excel pivot tables from Jira data? Defining the source dataįirst you need to render the source data in the Excel spreadsheet. Google for "Excel pivot table" - to find videos and tutorials for various experience levels.
"Pivot table" article in Wikipedia - to get a general overview.
Here is a collection of resources that we found useful: There are many great tutorials about Excel pivot tables in the web. In Excel, all these operations are really easy, mostly available via drag and drop. They also allow users to "drill down" the data to desired scope (e.g set the time resolution from year level to month level) and to filter data entries (e.g. They can quickly summarize large sets of data, sort and count that, calculate sum, average, minimum, maximum and other aggregate values. Pivot tables are really powerful tools for data analysis.
#Pivot tables in excel code#
Remember to read the related FAQ item, and adapt the code examples in this article correspondingly. Important note on non-English Excel versionsīetter Excel Exporter fully supports any Excel language version, but the function names, decimal and list separators depend on the language.