Quicklist Reports
This artilce explains the Quicklist reports available in Agility.
Overview
Quicklist reports are simple lists of assets displayed in grid format. Similar to a spreadsheet view, these reports allow you see asset data as a list but give you the added ability to filter and sort by the criteria you define.
How to Generate a Quicklist Report
- Click the hamburger menu
> Reports > All Reports. - Navigate to the appropriate section, and then click on the name of the quicklist you want to view.
Available Quicklist Reports
- Backlog Group Quicklist
- Backlog Item Quicklist
- Change Set Quicklist
- Commit Quicklist
- Dependency Quicklist
- Defect Quicklist
- Effort Quicklist
- Issue Quicklist
- Member Quicklist
- Milestone Quicklist
- Pipeline Run Quicklist
- Program Quicklist
- Project Quicklist
- Request Quicklist
- Retrospective Quicklist
- Sprint or Iteration Quicklist
- Stories or Backlog Item Quicklist
- Task Quicklist
- Test Quicklist
Use the Effort Quicklist to see individual effort entries to each project and iteration. Filter to a member, project, and iteration and sum the Done values to reconcile with Done amounts elsewhere in Digital.ai Agility.
How to Filter a Quicklist
Using filters, you can narrow or expand the types of data you want see by selection from a range of options.
- Click inside the filter text box at the top of grid, select from the filter options and enter the filter criteria.
- Add as many filters as you need and click Apply.
How to Sort Columns
Click on a column header to sort the data in ascending order of the value and click again to sort in the descending order.
How to Add Columns or Change the Number of Rows Per Page
-
In the top right corner of the page, click on the wrench icon, and then select Customize.
-
Select My Personal Settings from the "These customizations apply to" drop-down list.
-
If you want to:
-
- Select the check box in the Display column for each column you want to display. If you want to allow editing in that column, select the Edit check box.
- In the "Rows Per Page" field, enter the number of rows to display on each page.
-
Click Save.
How to Export to Excel
This feature is available in all editions.
Overview
Any data displayed in a grid can be exported to a Microsoft Excel spreadsheet that can be further formatted, printed, analyzed, or used in reports or presentations, etc.
The exported file will contain all the data in the columns in the grid, even if the data is spread across several pages.
Steps
- Click on the wrench icon in the far right corner of the page, and then select Export.
- Follow the prompts on your computer to save the file to your hard drive.
- To export data that is currently displayed in the grid, you can add them by following the instructions in theCustomizing Grids topic.
If you want to export closed work items only, see the Exporting Closed Work Items topic for instructions.
Important note on exporting
You may see an error message similar to this:
This happens because we export in Microsoft Excel-specific HTML format, but with xls extension, instructing the browser to open results via Microsoft Excel.
The warning about format mismatch should therefore be ignored.
To get the exported spreadsheet in native Microsoft Excel format (xls or xlsx), save it from Microsoft Excel using desired format.
How to Print Cards
Before printing cards, you can use filters or grid customizations to narrow or expand the card selections.
- In the top right corner of any grid, click on the wrench icon, and then select Print Cards.
- In the Print items as cards window, select the items you want to print, and then click the Generate Cards button.
- When the cards display in your browser, click the Print button. Note that you may need to modify the Page Setup settings to achieve the desired layout.
Related concepts
Using Tasks to Breakdown Stories Backlog Items