How do I format the results set in Ask Your Data?

In Ask Your Data, you have several options to customize the table display for enhanced analysis and readability. For each column, which is titled based on your prompt, you can access formatting options to sort data in ascending or descending order, pin columns to the left or right for fixed visibility, or hide columns that are not currently relevant.

Additionally, you can manage columns more broadly by searching for specific ones and controlling their overall visibility, including options to hide or show all columns at once, allowing you to tailor the presentation to your specific needs.

Note: Sub-account administrators can use Ask Your Data (AYD) directly within their own sub-accounts, where AYD is scoped to display only the data relevant to that specific sub-account.

How do I format the results set in Ask Your Data?

How do I format the results set in Ask Your Data?

1. View Data Results Table

In the data results table, the columns display the title based on your prompt in the chat window.

View Data Results Table

2. Open Column Format Options

To view format options, click the column format menu.

Open Column Format Options

3. View Column Format Options

Each column displays the following formatting options: Sort by Ascending, Sort by Descending, pin column to the left, pin column to the right, hide column and manage columns.

View Column Format Options

4. View Manage Column Options

The manage column options allow you to find a column, select visibility for columns, hide all columns, or show all columns.

View Manage Column Options

This guide covered how to format the results set in Ask Your Data.