Pinning work item query counts to the dashboard

Navigate to a query and click on the little arrow to the left of the query item in the query explorer. This will pop up a context menu. Click on Pin to homepage, as shown in this screenshot:

After you have clicked on Pin to homepage, you will notice that the query now has a pinned icon next to it.

Now, if you navigate back to the dashboard by clicking on HOME and then on Overview (if it is not open by default already), you will notice that there is a new tile on the dashboard for this query.

Blue tiles are for queries, and they display a count of the work items returned from a particular query. These tiles are clickable and will take you to that query in the queries tab if you click on them.

Pinning work item query charts

Before we can pin a query chart to the dashboard, we need to create the chart.

The easiest way to do this is by clicking on the tile on the dashboard from the query that we created earlier. This will take us to the query results view. Click on Charts, as follows:

You will notice that by default, there are no charts for a query. To create a new chart, click on the New Chart button, as shown here:

This will open up the CONFIGURE CHART dialog, as shown in the following screenshot:

You are able to select how the chart orders its values. Commonly, this is ordering by Value or Label. For this field I prefer using label, the main reason being that when it's pinned, it's easier to consume the information in the charts because the same label value appears in the same place in the chart. In the case where the chart would be consumed once off, it would be a better solution to sort by value.

For now, we have all the columns we need, so let's select State for Group by, add by State to our title, and then click on OK, like this:

Now, we have created a chart and it shows as a saved chart for this query. From here, we can simply click on the ellipsis and then click on Pin to homepage, as shown in this screenshot:

Visually, nothing will change on this page, letting you know that it is now on the home page. However, if you click on the ellipsis again, you will see that it now says Unpin from homepage, like this:

If we navigate back to the home page now, we will see that our chart is visible as well.

You pinned a basic query and a basic chart to the dashboard, but you can imagine with the various chart types available how much insight this can give to a team with just a glance on their dashboard. You can get more information about charts from MSDN by going to https://msdn.microsoft.com/Library/vs/alm/Report/charts.