Tile visualizations

Tiles are a useful way to present summary data in workbooks. The following example shows a common use case of tiles with app-level summary on top of a detailed grid.

Workbook tiles support showing items like a title, subtitle, large text, icons, metric-based gradients, spark lines or bars, and footers.

Add a tile

1. Switch the workbook to edit mode by selecting the Edit toolbar button.

2. Select Add > Add query to add a log query control to the workbook.

3. For Query type, select Logs. For Resource type, select, for example, Application Insights, and select the resources to target.

4. Use the query editor to enter the KQL for your analysis.

   requests
   | summarize Requests = count() by appName, name
   | top 7 by Requests desc
   

5. Set Size to Full.

6. Set Visualization to Tiles.

7. Select the Tile Settings button to open the Tile Settings pane:

   1. In Title, set:
      • Use column: name
   2. In Left, set:
      • Use column: Requests
      • Column renderer: Big Number
      • Color palette: Green to Red
      • Minimum value: 0
   3. In Bottom, set:
      • Use column: appName

8. Select the Save and Close button at the bottom of the pane.

The tiles in read mode:

Spark lines in tiles

1. Switch the workbook to edit mode by selecting Edit on the toolbar.

2. Add a time range parameter called TimeRange.

   1. Select Add > Add parameters.
   2. In the parameter control, select Add Parameter.
   3. In the Parameter name field, enter TimeRange. For Parameter type, choose Time range picker.
   4. Select Save at the top of the pane and then select Done Editing in the parameter control.

3. Select Add > Add query to add a log query control under the parameter control.

4. For Query type, select Logs. For Resource type, select, for example, Application Insights, and select the resources to target.

5. Use the query editor to enter the KQL for your analysis.

   let topRequests = requests
   | summarize Requests = count() by appName, name
   | top 7 by Requests desc;
   let topRequestNames = topRequests | project name;
   requests
   | where name in (topRequestNames)
   | make-series Trend = count() default = 0 on timestamp from {TimeRange:start} to {TimeRange:end} step {TimeRange:grain} by name
   | join (topRequests) on name
   | project-away name1, timestamp
   

6. Select Run Query. Set TimeRange to a value of your choosing before you run the query.

7. Set Visualization to Tiles.

8. Set Size to Full.

9. Select Tile Settings:

   1. In Tile, set:
      • Use column: name
   2. In Subtile, set:
      • Use column: appNAme
   3. In Left, set:
      • Use column:Requests
      • Column renderer: Big Number
      • Color palette: Green to Red
      • Minimum value: 0
   4. In Bottom, set:
      • Use column:Trend
      • Column renderer: Spark line
      • Color palette: Green to Red
      • Minimum value: 0

10. Select Save and Close at the bottom of the pane.

Tile sizes

You have an option to set the tile width in the tile settings:

• fixed (default)

  The default behavior of tiles is to be the same fixed width, approximately 160 pixels wide, plus the space around the tiles.

  

• auto

  Each title shrinks or grows to fit their contents. The tiles are limited to the width of the tiles' view (no horizontal scrolling).

  

• full size

  Each title is always the full width of the tiles' view, with one title per line.

  

Next steps

• Tiles also support the composite bar renderer. To learn more, see Composite bar documentation.
• To learn more about time parameters like TimeRange, see Workbook time parameters documentation.