Project Audit Use Cases

1. Load your CSV up with your spreadsheet software of choice and enable filters.

2. Sort your data first by Number of issues, then by Issues created in the past 30 days.

3. You might choose to filter by Status so that you only look at Active projects.

The number of issues won't be a perfect indicator of how valuable the project is as it may leave out new relevant projects, this exercise will simply give you a broad view to get you started with assessing your usage and requirements.

To get a better view of the usage in recent days you can add an extra column that calculates the value of Issues Created in the Past 30 days/Number of Issues. This will identify recently created projects compared to old established projects.

1. Load your CSV up with your spreadsheet software of choice and enable filters.

2. Filter your data to show projects with a value of 0 in Issues created in the past 30 days.

4. You may also want to filter further to also only show projects with a value of 0 in Issues updated in the past 30 days. 

3. You might choose to filter by Archived so that you only look at Active projects.

These projects might still be required, so be sure to look into each one fully before making your final decisions!

1. Load your CSV up with your spreadsheet software of choice and enable filters.

2. Filter by the Archived column to reveal all projects in the Archived status.

1. Load your CSV up with your spreadsheet software of choice and enable filters.

2. Sort your data smallest to largest by Issues created in the past 30 days.

4. You may also want to sort by two columns including the Issues updated in the past 30 days.

3. Filter by Archived so that you only look at Active projects.