Explore data in Real-Time Dashboard tiles (preview)

  • Article

The explore data feature enables you to delve deeper into the data presented in any Real-Time Dashboard. If the information you're seeking isn't readily available on the dashboard, this feature allows you to extend your exploration beyond the data displayed in the tiles, potentially uncovering new insights.

Important

This feature is in preview.

Even if a dashboard is shared with you and you only have viewer permissions, you can still explore it. The exploration process begins with viewing the data and its corresponding visualization as they appear on the tile. From there, you can further explore the data by adding or removing filters and aggregations, and viewing your results using different visualizations, all without needing any knowledge of the Kusto Query Language.

This exploration can provide additional insights into your data, enhancing your understanding and decision-making capabilities.

Prerequisites

Start your data exploration

  1. Within your workspace, select a Real-Time Dashboard.

  2. On the tile that you'd like to explore, select the Explore data icon.

    Screenshot of a Real-Time Dashboard tile showing the explore data icon highlighted.

Explore data

When you open the explore data window, you start with the same visualization as shown in the tile.

Screenshot of a Real-Time Dashboard explore data window with the different areas highlighted.

In the explore data window, you see the following areas:

A. Filter and aggregations bar: Shows filters and aggregations from the original query, added filters and aggregations, and the refresh data button.

B. Visual pane: Shows the visualization of the query data.

C. Results pane: Show the tabular results of the query data and the query in the Results and KQL tabs respectively.

D. Columns pane: Shows the query columns and their metadata, value distributions, and sample values depending on their data type.

You can then explore your data without affecting the visualization shown in the tile in the following ways:

  • In the filters bar, you can remove, add, and modify filters and aggregations from the query.

    Filters that came from the original tile query can't be modified and can only be removed in reverse order. You can add your own filters and aggregations, which you can later modify or remove as you explore.

    To add a filter:

    1. Select + Add.

    2. Find and select the column you'd like to filter.

      Screenshot of the filter dialog box showing how to select a column.

    3. Select the filter Operator and Value, and then select Apply. The visual, results, and KQL query update to reflect the new filter.

      Screenshot of the filter dialog box showing how to select an operator and a value.

    To add an aggregation:

    1. Select + Add > Aggregation.

      Screenshot of the aggregation dialog box showing how to select an aggregation type.

    2. Select the filter Operator and Display Name, optionally add up to two columns to group by, and then select Apply. The visual, results, and KQL query update to reflect the new filter.

      Screenshot of the aggregation dialog box showing how to select aggregation options.

  • From the Visual type dropdown, select other visual types to visualize your data in different ways.

    Screenshot of the visual pane, showing the drop down selector options.

  • Select the Results and KQL tabs to view the tabular query results and the underlying query respectively. As you explore, you see the changes you make updated in these tabs.

    Schreenshot of the query pane, showing the query for the visual.

  • In the Columns pane, you can browse the table schema by looking at the columns or finding a particular column. You can also choose columns to see their top values, value distributions, and sample values depending on their data type, as follows:

    Screenshot of the Columns pane, showing the columns with their metadata.

Related content