Chat with Data Assistant queries in the Run section of the Agentic Hub can be adjusted in natural language after the query has been executed. This means you can change the output format, apply filters, sort the results, obtain a timeline, and generate rankings.
To use a Chat with Data Assistant from Run, it must already be created and configured. For the configuration steps, see How to create a Chat with Data Assistant.
Once you select the Assistant and start a conversation, type your query in the chat box and press Enter or click the send arrow. The header of the conversation displays the Assistant name, its state and its version, and each conversation opens in its own tab at the top of the central working area.
Below, you will find examples that illustrate how to change the output format, apply filters to the data, sort the output, obtain a timeline, and generate a top X of specific data.
The Assistant has 4 possible display formats:
- Card: statically represents the query value, showing its trend.
- Chart: visually represents data with various types available, such as column, bar, line, area, pie, timeline, radar or polar charts.
- Table: displays data in a static format with fixed rows and columns.
- PivotTable: displays data in a table format that allows for flexible column swapping and grouping of information.
When you perform a query and do not specify an output format, the Assistant automatically selects the most appropriate format according to the type of data and the nature of the query performed.
To request a static table, indicate the format in the query. For example, 'Show, in table form, the number of patients by continent and country'. Tables and PivotTables are paginated: below the data, you can set the number of rows shown with Per page and move between pages with the navigation controls.
To obtain the same data in a format that allows columns to be swapped and information to be grouped, request it explicitly. For example, 'Displays the number of patients by continent and country in table format, allowing columns to be swapped and information to be grouped flexibly'. The Assistant returns a PivotTable, where you can sort each column and drag fields to the Drop filters here area.
If you prefer to represent the same query in a graph, you can express it as 'Show in a graph the number of patients by continent and country'. In this case, the Assistant uses a bar chart as the output format.
To select a specific type of chart, you only need to clarify the desired format. For example, if you wish to represent the number of patients by continent and country in a pie chart with the most representative data, specify: 'Display the number of patients by continent and country in a pie chart, showing the most representative ones'. In response, the Assistant generates a pie chart with the requested data.
You can alter the order of the data returned by the query by simply requesting it. For example, you could request 'Sort by number of confirmed cases in descending order'.
To generate a ranking and display the main results, you must request it in natural language. The Assistant sorts the data in descending order according to the value you indicate and displays the first X results. For example: 'Top 3 countries with the most sick people'.
To represent the evolution of a value over time, describe the period and the axes in the query. For example: 'Display a timeline showing the total number of COVID-19 cases in Uruguay. The result should be displayed as a line chart with Date on the X-axis and Total cases on the Y-axis'.
You can adjust several properties of the query according to your needs. For example, you can add a title by typing: 'Set the following title: Countries with the most cases'. You can also change the Y-axis title with the instruction: 'Y-axis title is Number of cases'. These actions allow you to customize further how the data is displayed.
You can apply filters by referring to the field and value you want to consider. For example, if you have obtained a ranking of the countries with the most cases of a disease, you can apply the filter 'Only for countries in North America'. This refines your query and displays the data specifically for that region.
You can also filter by date. For example, following the example of 'Only for countries in the Americas', you can use expressions such as 'between 2022 and 2024' to limit the range of dates you want to consider.
Since version 2026-06.