Show a value only in a dashboard in azure?

Question

I have following query:

AppMetrics | where Name=="ReportImported"| summarize Value=count() 

I would like to show the value in a dashboard, and it looks like this:

Is there anyway to only display the number and not having it displayed as a list with a Value column?

Answer 1

You can use an Azure Monitor Workbooks to achieve this.

1. From your Azure Portal, go to Monitor and look for Workbooks on the left pane. Then click New to create a new Workbook, followed by the Add query button.

2. At this point you can already paste your query in the query console window. Select your Log Analytics Workspace and make sure to run the query to validate it works. Under the Visualization drop-down, choose Tiles and a new Tiles settings will appear on the right. Click on that to bring up the settings page.

3. Here the only thing I configured was the Left Tile field. Set your values accordingly and check the custom formatting box. Click Apply to see the changes reflect. You can explore other features here and then click on Done editing if you're satisfied. Finally, click on Done editing and save your workbook.

4. Now for the next step, the Workbook needs to be in edit mode again. Edit it and then click on the Pin icon. A pop-up shows up, explaining two options you have for pinning. Look to the right you'll see another 'item-level' pin. Click on that and choose your dashboard.

5. It should show up in your dashboard with the Workbook name as the title and a number as the only content of the tile.

It might seem a bit complex but that's the only method I found today, after struggling for a solution for a few weeks. Workbooks are very powerful and allow for very rich visualization!