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

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 might already have been run from the previous section in this tutorial. This query returns a column chart showing the most recent number of bikes by BikepointID.

   AggregatedData
   | sort by BikepointID
   | render columnchart with (ycolumns=No_Bikes,xcolumn=BikepointID)
   

   

2. Select Save to dashboard > New Real-Time Dashboard.

3. Enter the following information:

   Field	Value
   Name	TutorialDashboard
   Location	The workspace in which you have created your resources

4. Select Create.

The new Real-Time dashboard, TutorialDashboard, opens with the New 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

Make sure that you are in Editing mode in the dashboard before beginning the following steps. If you are not in Editing mode, toggle from Viewing on the top right corner of the dashboard.

1. Select New tile.

2. In the query editor, enter and run the following query:

   RawData
   | where Timestamp > ago(1h)
   

3. Above the results pane, select + Add visual.

4. In the Visual formatting pane, enter the following information:

   Field	Value
   Tile name	Bike locations Map
   Visual type	Map
   Define location by	Latitude and longitude
   Latitude column	Latitude
   Longitude column	Longitude
   Label column	BikepointID

5. Select Apply changes. You can resize the tiles and zoom in on the map as desired.

   

6. Save the dashboard by selecting the Save icon on the top left corner of the dashboard.

Related content

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

• Create a Real-Time Dashboard
• arg_max() function
• render operator

Next step