Using commands for Conversational Analytics

You can specify highlighting data points in colors via commands, enabling users to enhance their visual analytics experience. This improves data insights with greater clarity and impact by emphasizing key metrics visually and distinctly.

This feature allows you to:

1. Highlight critical data points with custom colors to make patterns, trends, or anomalies instantly recognizable.

2. Use commands to automate the highlighting process, saving time while ensuring consistency across dashboards.

General commands

•  Show tips or guidelines: This command would show the best practices for using conversational analytics for better accuracy. 
  For examples:   

  • Show tips 

  • Give me guidelines for using Kyvos Dialogues. 

  • Provide general system guidelines. 

• Show Metadata: This command would show all the details related to a semantic model, including the Semantic model logical view and the description of different fields present in the semantic model. 
  For examples:

  • Show metadata 

  • Give me a description of the fields used. 

  • Give me details about the semantic model. 

• Show supported commands: List of support currently supported. 
  For examples: 

  • Give me the command list. 

  • Supported command details 

  • What are the different commands I can execute 

4. Clear the chat or conversation in view. 
   For examples:  

   • Clear the chat 

   • Clear all messages 

   • Empty chat area   

Visualization settings

It includes commands related to different viz settings, which are as follows- 

• Change the visualization or chart type. 
  For examples: 

  • Change chart type to Bar chart 

  • Show tree map 

  • Change to area 

• Change the chart type of a particular metric. 
  For examples: 

  • Show Sales as a line chart. 

  • Present Profit as dot plot 

• Move the measure to the left/right or top/bottom axis. 
  For examples:

  • Move sales to the left and profit to the right axis. 

  • Shift sales and profit to the top. 

  • Move all measures to the left axis. 

  • Move to the top axis – All visible measures will shift if no measures are specified. 

• Show or hide data labels for a specific metric. 
  For examples:

  • Show data label for sales. 

  • Hide values for all measures. 

  • Show values – If no measures are specified, it will show values for all visible measures. 

  • Turn on data labels – If no measures are specified, it will show values for all visible measures. 

• Change the highlight color for the field. 
  For examples:

  • Change the highlight color to red for the country. 

  • Change the highlight color to blue – If no fields are specified, the color of all highlighted fields will be changed. 

Data specific commands

It includes those commands which change the data in a visualization, which are as follows- 

• Change max rows to ‘X’ number. 
  For examples: 

  • Change max row to 5  

  • Show a maximum of 12 rows. 

• Highlight Fields 
  For examples: 

  • Highlight countries where sales are above 20000, and profit is below 10000 

  • Highlight profit where it is higher than cost. 

• Remove highlighting
  For examples: 

  • Remove highlighting from the Sales. 

  • Discard complete highlighting - If no fields are specified, the highlight will be removed from all highlighted fields. 

  • Remove highlighting – If no fields are specified, highlighting will be removed from all highlighted fields. 

Cases when executing multiple commands are supported in a single question

• Users can execute multiple visualization setting commands in a single question.
  For examples: 

  • Show sales as a line chart and move it to the right axis. 

  • Move sales and discounts to the bottom axis to show values for sales and hide labels for discounts. 

  • Change the highlight color to blue, move sales to the right axis, and show sales as an area chart. 

  • Show the area chart and the data label for sales. 

• Users can execute multiple data-specific commands in a single question.
  For examples: 

  • Highlight the Country where sales are above 20000 and remove the highlight on profit. 

  • Remove the Highlight on the country and highlight the country starting with ‘A’ in blue. 

• Executing a business query with a generic command will allow the business query to run, but the command part will be ignored. The results of the business query will be displayed in the view, while the UI will show an error message for the command part that could not be executed.
  For examples:

  • Show category-wise sales and clear the conversation. 

  • What are the top 10 cities by profit? also, including the command list. 

• Executing a viz setting command along with a business query will work.
  For examples:

  • Show category-wise sales as an area chart. 

  • What are the top 10 countries by profit, and show a profit as the right axis? 

• Users can execute business queries and the max row command from the category of the specific command. 
  For examples:

  • Give me the monthly sales trend for 2013 and show a max of 20 rows only. 

• Users can execute viz setting commands and the max row command from the data-specific commands category.
  For examples:

  • Move sales to the top axis and change the highlight color for the country to red. 

  • Show values for all measures and change the max row to 20. 

Cases when executing multiple commands are not supported in a single question

• Executing multiple generic commands in a single question is not supported. An error will be displayed on the UI if the user tries to do so.
  For examples:

  • Show tips and include the command list. 

  • Show metadata info and clear the chat. 

• Users will see an error on the UI if they attempt to execute data-specific or visualization-setting commands alongside generic commands.
  For examples:

  • Move sales to the right axis and clear the conversation. 

  • Show values for sales and show metadata details. 

• Execution of highlighting commands with business queries or any other command is not supported, and users will see incorrect results if tries to do so.
  For examples:

  • What are the top 10 country by profit and highlight country where sales are positive and profits are negative  

  • Highlight the category where sales exceed profit, move sales to the right axis, and show their values. 

Tips or Guidelines for Using Highlighting Commands- 

• Users can highlight data points based on multiple conditions, and these conditions include only those fields that are visible in the current view.
  For examples: 

  • Highlight category where sales are above 2000 and discount is lower than profit values and Country is USA. 

• Users can apply multiple conditions using both 'and' and 'or' relationships.
  For examples: 

  • Highlight sales where it is below 3000 or above profit values in green color. 

• Users can highlight multiple fields simultaneously in a single question.
  For example:
  Let’s say the user is currently viewing country and category values by sales and profit. To highlight multiple fields simultaneously user can execute: 

  • Highlight country where sales are above 50000 in green and category where profits are negative. 

  • Above will highlight all countries where sales are above 50K in green color and highlight all categories data points where profit values are negative. 

• If highlighting is applied on a field and, in the subsequent question, the user requests to apply highlighting on the same field again with different conditions, as a result highlighting will be combined, and the data will be highlighted with both sets of conditions applied. 

• If no color is specified in the question, the default color will be green for positive values and red for negative values. 

• To apply highlighting on a numeric field, use criteria's such as is, greater than, greater than or equal to, less than, less than or equal to, between, or other similar comparisons.  

• To apply highlighting on a character field, use criteria's such as is, is not, is in the list, is not in the list, starts with, ends with, contains, is blank, is not blank or other similar comparisons. 

• To remove highlights on any field users can execute below set of commands or something similar.
  For examples:

  • Remove highlighting on country. 

  • Remove highlighting – If no field is specified, highlighting will be cleared from all highlighted fields. 

• Users can also change the highlight color via natural language command.
  For examples:

  • Change highlight color to red for Category 

  • Change highlight color to green – If no field is specified, then color will be changed for all highlighted fields. 

• To update or modify highlighting on any field, users can execute below set of commands or something similar.
  For examples:

  • Modify highlight on country where sales are above 2000 

  • Update highlight on sales which is below avg sales value.