Edit

Share via

Real-Time Intelligence tutorial part 4: Create a Real-Time Dashboard

  • Article

Note

This tutorial is part of a series. For the previous section, see: Tutorial part 3: Query streaming data in a KQL queryset.

In this part of the tutorial, you learn how to create a Real-Time Dashboard in Real-Time Intelligence. You create a Kusto Query Language (KQL) query, create a Real-Time Dashboard, add a new tile to the dashboard, and explore the data visually by adding an aggregation.

Create a Real-Time Dashboard

  1. In your KQL queryset, copy/paste, and run the following query. This query returns a column chart showing the most recent number of bikes by BikepointID.

    Note

    Your KQL queryset comes prepopulated with several queries. Make sure there's an empty line between any existing query and the new query you're adding, so that you can run this query separately.

    TutorialTable
| summarize arg_max(Timestamp, No_Bikes) by BikepointID
| sort by BikepointID
| render columnchart with (ycolumns=No_Bikes, xcolumn= BikepointID)

    Screenshot of query showing column chart of bikes by bike point ID.

  2. Select Pin to dashboard.

  3. Enter the following information:

    Screenshot of pinning query to dashboard in Real-Time Intelligence.

    Field Value
    Create new tile In a new dashboard
    Dashboard name TutorialDashboard
    Tile name Recent bikes by Timepoint
    Open dashboard after creation Selected

  4. Select Create.

Since you've selected Open dashboard after creation, the new Real-Time dashboard, TutorialDashboard, opens with the Recent bikes by Bikepoint tile. You can also access the Real-Time dashboard by browsing to your workspace and selecting the desired item.

Add a new tile to the dashboard

  1. On the top menu bar, toggle from Viewing mode to Editing mode.

  2. Select New tile

    Screenshot of Real-Time Dashboard in editing mode with new tile selected.

  3. In the query editor, enter the following query:

    TutorialTable
| where Neighbourhood == "Chelsea"

  4. From the menu ribbon, Select Apply changes. A new tile is created.

  5. Rename the tile by selecting the More menu [...] on the top right corner of the tile > Rename tile.

  6. Enter the new name Chelsea bikes to rename the tile.

Explore the data visually by adding an aggregation

  1. On the new Chelsea bikes tile, select the Explore icon.

    GIF of how to visually add and modify the query.

  2. Select + Add > Aggregation.

  3. Select + Add grouping.

  4. Select Group by > Street.

  5. Select Apply.

    Notice that the query elements are updated to include the green count() by Street aggregation. The resulting table changed to show the total count of bike locations by street.

  6. Close the Explore pane and select Save from the menu ribbon to save the changes.

Related content

For more information about tasks performed in this tutorial, see:

Next step

Tutorial part 5: Create a Power BI report from your KQL queryset