...
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.
...
Supported Commands for Multiple Conditions
Users can execute multiple viz 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.
...
Unsupported Commands for Multiple Conditions
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.
...