How to include 'Task' work item types?

[nbrown02]

Task are deliberately excluded from the dashboard, mainly because these alone do not relate to value. Counting a 'Dev' task in our Throughput chart for example would be misleading if the actual user story was not finished.

If you'd like to include 'Tasks' in your dataset, you will need to edit the queries in the report to do so...

[nbrown02]

To do this:

1. Go to 'Transform Data'

2. You'll need to find every table that has 'WorkItems xx' in the name, and then go to 'Source' on the right hand side.
   There is a line of text in the query that says: and%20WorkItemType%20ne%20%27Task%27%20

3. If you want to include Tasks with User Stories, PBI's, etc. then simply delete this text.
   If you want to include Tasks whilst excluding User Stories, PBI's, etc. then you need to change the text to: and%20WorkItemType%20ne%20%27TProduct%20Backlog%20Item%27%20and%20WorkItemType%20ne%20%27TUser%20Story%27%20